Is there a way in excel to prevent someone from "re-ordering" tabs in a workbook without using a macro?
I am using a sum formula that goes across multiple tabs, but noted when I rearranged the order of the tabs, that the results of the formula changed. After some minor research, I noted that I had moved a tab outside the "sum range" inadvertently.
I am trying to develop a spreadsheet that will calculate a cost based on a matrix. I am attaching a sample of the calculation created so far. The end result is in cell M13 and is highlighted in yellow. I kind of layed the formula out in a few different cells, so hopefully it would be easy to follow.
simplify this process with maybe another formula that I might not be aware of, or maybe show me how to get this done in VB code. I think VB code would be the correct way to go just not sure.
do you know if there is vba code to lock formulas so someone sees but does not touch and the same for values see but cant change??
my sheets with formulas are SUMMARY and Sheet2
sheet with value is TABLE
I have a spreadsheet that requires the user to use ALL CAPS when they fill it out. Is there a way to have VBA turn on the CAP Lock regardless of the persons keyboard setting? I have asked that the users use ALL CAPS but of course that leave a lot of room for error.
I'm looking at creating some templates that people will submit to me on a monthly basis but i'd like to 'lock' the workbook name, is this possible?
View 2 Replies View Related=IF(A4='Exported Data'!B2,'Exported Data'!C2,"")
How can I lock A so when I copy over to the right the formula doesn't change that reference to B4?
Is there a way to have the True value (Exported Data'!C2) reference one cell over instead of selecting the cell to reference from?
Is there a way to lock the title of the workbook so if someone else has it, they can't rename it even if they move it to their personal computer?
View 2 Replies View RelatedHaving a problem locking the sheet and still have it work. Not sure if their is a easy work around for this. Just lock sheet and see what I get.
View 7 Replies View RelatedWould like to set CAPS-LOCK On and Off using VBA. Can someone help please?
View 5 Replies View RelatedI have a excel document with 5 tabs (sheets) and, because different people work with a different tab (sheet), I want to lock each tab (sheet). I want the tab to be visible on the tab bar but when you click on it you will not be able to see the content of that tab (sheet) until you provide the right password (each tab with a different pasword).
View 2 Replies View RelatedHow do you programatically enable the CAPSLOCK key in VBA? I've tried:
Sendkeys "{CAPSLOCK}"
When I run this, Excel's status bar flashes "CAPS" for about 1 second then disappears. It seems to have no impact on the keyboard for case-sensitivity - which is what I'm shooting for.
Need code that would make cell J2 be populated with U no matter what was placed in cell J2 either manually or externally.
View 9 Replies View Relatedhow to lock a sheet in Excel 2007 so that no one can navigate to that sheet.
I can have amacro which will lock each cell where a "Y" or "N" is inserted........ eg the netire sheet is unprotected but the moment Y is inserted in C 5 the cell gets locked, next entry in D 10 has a N entry and that too upon entry get's locked
The idea being once Y or N is typed that cell can no longer be changed
I am aware of setting protection to certain cells by the Excel Options. which is unlocking the by defalut locked cells and then setting the sheet protect in tools->protection. I want this to be done through VBA code.
i have a template which has text in some cells and some cells are blank, i need to lock the cells which has text and keep the blank cells unlocked for user input. As this is a template it will be copied to another sheet, so i need to retain the protection properties in all new sheets (copied from the template). Attaching the template for which the protection needs to be done.As of now the sheet1 has protection property set through the toolbar properties.
How it is possible to lock the VBA coding and Modules? I mean when Some one want to view VBA coding the Password window should not appear, istead of that a message box appears with message something like "Not viewable"
View 9 Replies View RelatedI use the attached workbook to keep tack of feed use in turkeys. when a new flock is added to a farm (Airport View or Home farm) A template is copied and pasted from the "templates" sheet depending on what type of diet they will be on. (Ralco ABF or Ralco Standard) that template refers to the Ration sheet to calculate how much corn is in each diet. After a flock is complete I will never change the numbers again, it is just for record keeping. I want to be able to change the Corn/ton numbers in a ration (on the rations tab) if need be and not affect all the older completed records.
View 1 Replies View RelatedI want lock a picture in excel like logo, if i copy that logo and past in another sheet the position should be same as parent sheet.
View 1 Replies View RelatedHow to lock a formula column that need a password in editing the formula
View 3 Replies View RelatedCan we lock or disable text box editing in excel without protecting sheets?
View 1 Replies View Related I have a multisheet excel workbook that I am programming. I was wondering if there is a way to lock a cell on one sheet after the initial value was put in, allowing me to change it later. This may not be so clear so here is the problem....
I have Workbook1. The input from cell A3 on Sheet1 is 5. I have made a second sheet called Order Form. In cell B5 of Order form I have made it ='Sheet1'!A3. I am looking for a way to be able to change cell A3 on Sheet1, but keep the 5 on Order Form.
I have an sheet(see attached) with some dummy data, now i want to lock (with password) only those cells depending on the dropdown (highlighted in sheet).For eg,if we select A from dropdown of col c and then locked from dropdown of col D , it should lock the complete row(s) of value A in col H and rows with value B shall remain editable.
View 14 Replies View RelatedI need to get rid of the option to DELETE a sheet. However, when I password protect the WORKBOOK (which does this fine) none of the Macro buttons will execute, even with Macro security settings set to ENABLE ALL.
Looks like I will need some VBA code to not allow any of the sheets in the workbook to be deleted.
I've done the following steps so far:
Tools
VBAFormatProperties
Checked the "Lock Project from Viewing"
Applied a password
and clicked Ok
Is there a way to protect a sheet from a user dragging a cell?
View 6 Replies View RelatedI have code written to auto save the active worksheet when a button on my user form is pressed. What I would like to know is if there is a way to lock the worksheet when the button that triggers the save event is pressed behind the scenes so the end user has a more difficult time editing the sheet. I know they can just resave the document and the protection will be gone, but for minimizing user manipulation.
View 2 Replies View RelatedI would like to know if I can lock the checkboxes on a listview. I have a form which loads information onto some textboxes once a listview item is selected, then the user will change the selected values on the textboxes and then, when the value is verified, the checkbox of the selected item should be checked.
View 3 Replies View RelatedIs there a way to 'lock' a page from being changed once it has been printed? It can be printed multiple times but want it to not be able to be edited once it has been printed. Thinking I could have a control button on the page maybe and once it has been checked ok to print then click the button and it saves it as is and uneditable?
View 3 Replies View RelatedI have a range of cells I want to become locked (thus, uneditable), based upon the value of another cell.
For example, if cell A1 is "True," (based on a drop-down, not a formula) I want cells B1:B10 to become locked. I want the user to be able to edit these cells only when A1 is false. Also, the sheet is already passsword protected.
I have a excel worksheet that I am looking to market and I want to give the prospective customer a 30 day free trial before purchasing my worksheet. What I would like to do it be able to lock the worksheet so it can not be used after 30 days and also display a message telling them that the trial period has ended. I would also like to keep all formula cells locked at all times to prevent unathorized copying of my calculations.
View 2 Replies View Related