Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    NE
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unprotecting Multiple Sheets (2000)

    I am wondering if there is anyway to unprotect mutiple sheets in a workbook. I have a workbook with about 50 sheets. I need to make one modification to all of them, but I can't do it while they are protected. I hate to spend all the time unprotecting and reprotecting each of them individually. Any suggestions?

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unprotecting Multiple Sheets (2000)

    I use an addin called spreadsheet assistant. Adds hundreds of useful functions, shortcuts, etc to excel.

    Go to www.add-ins.com and download the evaluation copy of the spreadsheet assistant. If you only used it long enough to do the the 50-sheet protection job and then deleted it, it would still save you time. Don't forget the "-" in add-ins.
    - Ricky

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Location
    NE
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unprotecting Multiple Sheets (2000)

    Thank You! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unprotecting Multiple Sheets (2000)

    A simple macro may help you a lot. Of course, here I assume that there is no password protection.

    <pre>Sub test()
    Dim oSheet As Worksheet
    For Each oSheet In Worksheets
    oSheet.Unprotect
    Next
    End Sub
    </pre>


    If this is the case, you should add the password after Unprotect in the code below. Like this:

    <pre>Sub test()
    Dim oSheet As Worksheet
    For Each oSheet In Worksheets
    oSheet.Unprotect("password")
    Next
    End Sub
    </pre>


    If you have a different password for every sheet, then you should change the code above so that each individual sheet is unprotected by its own password (I cannot imagine that you can keep track of 50 different passwords...)

Posting Permissions

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