Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Midwest USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Protection (2000)

    Hi. I am new here, so please forgive me if this has been covered before. I did do a search, but didn't find anything which addressed my problem.

    I have a spreadsheet on which I'd like to protect certain cells. No problem. I understand how to do that. Unfortunately, every time I set up protection for those cells, the cells I have unlocked also seem to have some protection. I need to be able to change the style (i.e. bold, color, fill, etc.) in the unlocked cells, but once I've protected the worksheet/workbook I can't seem to do that even in the unlocked cells. On the other hand, when I protect the worksheet in a way that allows those changes, I am able to change the contents of the cells I do want protected.

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

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

    Re: Cell Protection (2000)

    Unfortunately, when you protect a workbook one of the many things that gets disabled is formatting. As far as I know, there is no way to change that. If there are certain particular formats that you want to allow the user to change, then you can write a macro or macros that will unprotect the workbook, make the change, and then protect the workbook again. If you want to allow the user to make any format change, then you would have to write a macro that displayed a user form with all the changes he can make and then do the same as above.

    Welcome to the Lounge.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Location
    Midwest USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Protection (2000)

    That's too bad. It seems to me it would be more logical to at least give the protector the choice - to protect formatting or not to protect formatting - when s/he protects the worksheet. But then, when have we ever known Microsoft to be logical? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Thank you for your help, though. And thanks for the welcome. I've been an avid reader of some of Woody's newsletters for some time. It's really nice to know there's a place like this to come to for help. I'm sure I'll be back! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Protection (2000)

    You get a bit more choice with Excel 2002...
    Attached Images Attached Images
    • File Type: gif x.gif (5.9 KB, 0 views)

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

    Re: Cell Protection (2000)

    That would be a nice feature to have. Unfortunately, not nice enough to risk not having access to my data because the Registration/Activation Wizard doesn't like the phase of the moon.
    Legare Coleman

  6. #6
    New Lounger
    Join Date
    Feb 2002
    Location
    Midwest USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Protection (2000)

    LOL Legare! That's part of the reason I haven't upgraded my home system. At the office, I'm at the mercy of what passes for our tech support and their upgrade schedule. I'm hoping someone there has some sense and we don't upgrade for a while yet.

    Leif, thanks for the heads up. I knew there were some nice features to 2002, but I'm afraid the "undocumented features" far outweigh the documented ones!

Posting Permissions

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