Sheet Protection in a Workbook

[billmcm]

Hello All, I am using Excel 2007 and I have a workbook with 12 sheets (one per month). I have formulae that I wish to protect on each sheet so I have locked the appropriate cells and want to Protect each month. When I selected all sheets and went to Review on the Menu bar, the Protect Sheet function was "greyed out" and I then had to Protect each sheet individually. Is there a method that I can use that will Protect/Unprotect all 12 sheets at the one time? I look forward to your help.

 

[Andrew Poulsom]

Sorry no.

 

[billmcm]

Thanks for your prompt reply, even though it was bad news!!