View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BillFitz BillFitz is offline
external usenet poster
 
Posts: 10
Default Excel Worksheet protection

Is there a simple way to Protect/Unprotect individual worksheets in a file
without having to visit each worksheet.
I use a file containing 31 worksheets for each day of month and I can make
changes each month, to update for new product lines on each sheet, across all
worksheets using the Group function. However, in order to Unprotect and then
Protect each worksheet individually is a time consuming process.