Announcement

Collapse
No announcement yet.

Password Lock Hidden Column / Row

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ladysox
    started a topic Password Lock Hidden Column / Row

    Password Lock Hidden Column / Row

    Is there a way to lock a column hidden so that it can't be unhidden? Maybe with a password? I tried saving the file with a password but I could still go in and "unhide" that column. Again, I sincerely appreciate the great advise on this board!

  • jlsprink
    replied
    Re: Lock Column With Password?

    You're quite welcome.

    Leave a comment:


  • ladysox
    replied
    Re: Lock Column With Password?

    Thank you so very much for your help!

    Leave a comment:


  • jlsprink
    replied
    Re: Lock Column With Password?

    Hello,

    Hide the column and then protect the worksheet.
    Tools=>Protection=>Protect Sheet.

    First, you'll have to unlock each cell that you want the user to be able to modify.
    If the rest of the sheet can be modified, just select the entire sheet, right-click and choose format cells. Go to the protection Tab and uncheck the "Locked" box.

    HTH

    JL

    Leave a comment:

Working...
X