View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed P[_2_] Ed P[_2_] is offline
external usenet poster
 
Posts: 14
Default Un-protect Multiple Worksheets

I have a large workbook that contains approx. 80 worksheets. I have each
sheet protected individually with the same password.
Can anyone tell me if there is a way to unprotect all sheets at one time so
that changes can be made quicker and easier.
I tend to spend more time un-protecting and re-protecting the sheets due to
the multitude of sheets.
Thanks
Ed