Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Protect specific columns (2002)

    Just when I think I couldn't use another feature in Excel...
    Locking and unlocking cells, then protecting the worksheet seems to be an all or nothing proposition. I have a situation where I'd like to be able to lock various cells, but have one column, and only one column, unlocked (not a problem) and allow the user to change formatting in that column (e.g., background and bold/italic), but not change formatting elsewhere. Is there a way this can be done or do we need the 2008 release?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Protect specific columns (2002)

    The built-in options apply to the whole sheet. You could disallow all formatting in the Protect Sheet dialog, and provide a custom toolbar with buttons that run macros that
    - Unprotect the worksheet.
    - Apply formatting to a specific column.
    - Protect the worksheet again.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Protect specific columns (2002)

    Hi There

    This is quite easy. Say you want protect all columns apart from column A ,do the following:

    1) Select Column A
    2) Select Format --> Format cells
    3) Select the Protection Tab
    4) Deselect Locked, press OK
    5) Click Tools--> Protect Sheet
    6) Ensure Select Locked cells and Select unlocked cells are selected
    7) Press OK

    You will now be able to add text to the cells in Column A but nowhere else.

    You can repeat the method by selecting multiple cells using Ctrl+Click method. Thi swill protect all cells apart from the ones you had selected.

    Is this what you are looking for?
    Jerry

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protect specific columns (2002)

    True, but you still can't change the cell formatting without unprotecting the sheet.
    Legare Coleman

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Protect specific columns (2002)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    <img src=/S/note.gif border=0 alt=note width=20 height=20>to myself..always read the question very carefully
    Jerry

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: Protect specific columns (2002)

    Hans is right...unfortunately, for me. Maybe in another release sometime.

Posting Permissions

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