View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
santaviga santaviga is offline
external usenet poster
 
Posts: 178
Default Protection Macro

Hello.

I'm looking for a macro to run to protect all worksheets in a workbook, I
have about 50 worksheets and its a lot of work going through the protection
menu for every worksheet, Can someone give me a macro to run so when run it
protects all worksheets in the workbook and also one to run to unprotect all
worksheets in a workbook.

many Thanks