View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tomster3 tomster3 is offline
external usenet poster
 
Posts: 1
Default How can I unprotect multiple same passoword worksheets at once?

We have created a large number of workbooks containing worksheets that are
protected, except for a few cells, all with the same password. Is there any
way to remove protection from multiple worksheets at one time? We are trying
to avoid having to open each worksheet at a time, changing the one protected
text cell that needs changing, and then putting protection back on.