View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shawnlacey
 
Posts: n/a
Default Protection of identical cells on multiple worksheets

I have a weekly project report in Excell that needs to be filled out on a
weekly basis till the end of the year. Each sheet is the same and I only
want the user to be able to fill in the exact same cells each week and lock
down the rest of the sheet to protect the formulas. Is there a way to all
the sheets as opposed to having to lock each one individually??

Help Please!!