Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Password Lock Hidden Column / Row

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

  • 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!

  • #2
    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

    Comment


    • #3
      Re: Lock Column With Password?

      Thank you so very much for your help!

      Comment


      • #4
        Re: Lock Column With Password?

        You're quite welcome.

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X