View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dave caizley dave caizley is offline
external usenet poster
 
Posts: 19
Default password protect copies of workbooks

Hi

I have a master workbook that runs various macros to create a copy of a
selected sheet from the master into a new workbook.

Whilst I can protect the master, am I able to include within the macro code
that creates the copy, an instruction to protect all cells marked as locked.

Thanks in anticipation