Excel 2007 "Protect Sheet" option not available

[Fabz]

Hi there,

In Excel 2007 I tried to protect certain ranges. I don't know exactly what I
did, but suddenly the "Protect Sheet" option is no longer available (it's of
course still there but cannot be selected, only "Protect Workboo" is
selectable). I cannot figure out how to unlock the Protect Sheet option. Any
ideas?

Fabz

 

[Fabz]

Oh, this thread solved my problem:

http://www.pcreview.co.uk/forums/thread-1039062.php

When your sheets are "grouped" in the Excel Title Bar one can find the Title
"MySheet.xlsx [Group] - Excel 2007". It is sufficient to right-click on any
sheet tab and select "ungroup sheet". Then the "Protect Sheet" button is
highlighted again. (I actually cannot remember having grouped them myself,
but it seems that Excel is sometimes doing this for whatever reason.)

Greetz
Fabz