View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevhatch kevhatch is offline
external usenet poster
 
Posts: 14
Default Use Macro to protect choosen sheets in workbook

I have a workbook with 10 sheets, 7 sheets used for Data entry (which I don't
want anyone to be able to change) and 3 for anybody to work with the data on
a day to day basis without them being able to corrupt the original. I know of
the Macro to protect the whole workbook but what I would like is to be able
to protect the 7 Data sheets and leave the 3 working sheets unlocked. Hope
this makes sense to you.
Thx in advance