+ Reply to Thread
Results 1 to 3 of 3

Protect Sheet but Hide/Unhide Columns

  1. #1
    Registered User
    Join Date
    12-14-2008
    Location
    Minneapolis, MN
    Posts
    25

    Protect Sheet but Hide/Unhide Columns

    I have a speadsheet that has 27 columns for time entries, however employees seldom need to use more than the first 12 columns. I need to protect the sheet but would like the employees to be able to Unhide the columns when they need to use them, then reHide them. I can't find this as an option in either 2003 or 2007. Any suggestions?

    Thank you for your help,
    Ray
    Last edited by N164PJ; 12-17-2008 at 07:52 PM.

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Try this

    When you protect the sheet there are several options. put a check in the box for format columns and even protected you can unhide columns.
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Registered User
    Join Date
    12-14-2008
    Location
    Minneapolis, MN
    Posts
    25

    Protect Sheet but Hide/Unhide Columns

    Sweet, I figured it was probably easy but couldn't get there.

    Thank you,
    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1