locking cells

  1. M

    prevent cells from being edited

    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
  2. S

    Conditional Protection (IF then unlock kind of thing..)

    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...
  3. L

    Locking a cell with VBA if another cell contains information

    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...
  4. C

    Locking Cells

    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...

Some videos you may like

This Week's Hot Topics