Excel 2007 "Protect Sheet" option not available

F

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top