locking cells

I have a price worksheet with drop down menus. the salespeople can fill in all data necessary and it will calculate pricing and sales tax etc. the problem is that they can also change fornulas by typing over a formula. how do you protect certain cells but still allow functionality <input...

Ctrl+PgDn normally takes you to the next worksheet If a worksheet is unprotected, or protected with all cells locked, this works fine. If a worksheet has a mixture of locked and unlocked cells and is protected with "select unlocked cells" allowed, Ctrl+PgDn works differently and moves you across...

Hi all, I have a workbok with numerous sheets. On various sheets i want to stop the user from being able to alter information in the rang D4:AS4. Is there a quick macro to do this? Many thanks

No idea whether this is even possible, BUT here's my question: Can you apply a conditional lock to a cell? I'm envisioning a formula that looks something like this: IF A1 = "New Hire" then unlock A2, otherwise VLOOKUP..etc.. so A2 would have a different lock/unlock status depending on the value...

Hi! The linked thread shows almost exactly what I'm looking to accomplish.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> http://www.mrexcel.com/forum/showthread.php?p=1572477 <o:p></o:p> <o:p></o:p> But as I know very little about VBA, I have a few...

I did review some examples your members have already provided however I have a slight twist. I have multiple users adding to a spreadsheet from which data is later copied to a master sheet. I need to lock ONLY cells which contain data when user chooses to save spreadsheet or saves speadsheet...