View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dympna.kearney@dhsspsni.gov.uk is offline
external usenet poster
 
Posts: 2
Default password protect multiple worksheets in excel

Can anyone help me, I am trying to find a vba code that will allow mw
to select a number of excel worksheets to apply protection to in one
go.
I have a workbook with 50 w/sheets and i only need to protect 30 of
them can i get a code that will allow me to choose the relevant sheets
that I wish to protect without all of the worksheets in the workbook
being protected.
I used to have a macro that did this but my version of excel was
updated and I lost the macro on my personal.xls.

Can anyone help!