View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Storm Storm is offline
external usenet poster
 
Posts: 58
Default Unprotecting Worksheets

Hello.

I have a file that has multiple worksheets, each are protected (locked) with
a similar password for each worksheet. Is there a way to unprotect all
worksheets all at once without having to click on each sheet and unprotect it
that way? Is there a Macro? Or something?

Thank you!
Storm