Protect Sheet not working after protecting workbook?

Hi there,

I am using Excel 2011 for Mac.

I have a workbook I've made and want to protect the formulas from accidentally being overwritten. I was able to protect the sheets by locking and unlocking various cells within each sheet and then going to Tools/Protection/Protect Sheet. It was working great.

I saw that it was possible to protect a workbook and wondered if that would accomplish the same thing without having to protect each sheet individually. It didn't, so I unprotected the workbook.

Trouble is, now the option to protect a sheet is greyed out and I'm unable to use it.

What did I do and how do I fix it?

Teri

I figured it out! Excel had grouped my sheets together. I went to the tab for one of the sheets and clicked on "ungroup sheets" and now I have the protect sheet function back.

Phew!