Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet Protection (Office 97)

    Is there a way to protect or unprotect multiple worksheets at once that have the same password? I have a spreadsheet that tracks auto use where I work. Some time I have to go into it and make changes to every sheet. I have to go in and unprotect and then protect after making changes with every sheet. When your dealing with over 30 sheets it gets to you.
    Thanks for any help or guidance.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Worksheet Protection (Office 97)

    Check the thread beginning with <post#=387912>post 387912</post#>

    To protect the worksheets modify the VBA to use .protect instead of .unprotect

Posting Permissions

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