Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Won't Unprotect (2003)

    Longers - I've been working on the attached spreadsheet (for some time) and I find now that although the I've unprotected the respective worksheets the spinners bars won't unprotect and I get that "protection" message. Not sure if there is something in the code causing this or if is some Excel glitch (I hope not!).
    If some kind person out there could have a look at the attachment and let me know what the problem might be. Password to see all tabs = admin

    Thanks <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

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

    Re: Won't Unprotect (2003)

    The scroll bars are all linked to cells in "Summary Sheet" and that worksheet is still protected. If you unprotect "Summary Sheet", you will unlock all the scroll bars.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Won't Unprotect (2003)

    Hans - you're a marvel!!.
    Is there anyway to protect the formulas in the summary sheet but not the scroll bars in the associated sheets?

    Regards <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

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

    Re: Won't Unprotect (2003)

    Select the cells in columns F and H of Summary Sheet that are linked to the scroll bars.
    Select Format | Cells, Protection tab, and clear the Locked check box, then click OK.
    Then re-protect the worksheet. The formulas will be locked, but since the cells linked to the scroll bars have been unlocked, the scroll bars will work.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Won't Unprotect (2003)

    Hans - Thanks again!!

  6. #6
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Won't Unprotect (2003)

    <P ID="edit" class=small>(Edited by Servando on 09-Apr-04 19:43. )</P>Verada:
    Some changes

  7. #7
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Won't Unprotect (2003)

    Servando - Thank you for your assistance!!

Posting Permissions

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