Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Password Lock Hidden Column / Row

  1. #1
    Join Date
    18th February 2008
    Posts
    4

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th February 2004
    Location
    Florida
    Posts
    181

    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    18th February 2008
    Posts
    4

    Re: Lock Column With Password?

    Thank you so very much for your help!

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th February 2004
    Location
    Florida
    Posts
    181

    Re: Lock Column With Password?

    You're quite welcome.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Lock Non Contiguous Cells On Hidden Sheet
    By mrfitness in forum EXCEL HELP
    Replies: 5
    Last Post: October 20th, 2007, 10:15
  2. Password Protecting Hidden Sheets
    By simonpnewman in forum EXCEL HELP
    Replies: 12
    Last Post: July 27th, 2007, 19:45
  3. Lock Cells, Protect Sheet With Password & Time Stamp
    By jcmondelli in forum EXCEL HELP
    Replies: 3
    Last Post: July 19th, 2007, 14:56
  4. Lock Cells Based On Entry In Other Column
    By lostyankee in forum EXCEL HELP
    Replies: 4
    Last Post: April 3rd, 2007, 04:59
  5. Lock Cells Depending On Other Column Values
    By bryceo in forum EXCEL HELP
    Replies: 1
    Last Post: March 7th, 2007, 02:28

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno