Protection greyed out in Excel

B

brett_boal

When would Tools -> Protection be greyed out? This isn't a shared
workbook and the workbook is unprotected, but the worksheet is
protected and I have the password. Unfortunately Tools -> Protection
is not available. I'm using Excel 2003, professional edition, although
I previously saved this workbook in an earlier version of Excel.
 
J

Jim Rech

I don't know why this would happen unless a macro disabled this command.
Try using View, Toolbars to display the Protection toolbar as an alternate
approach.

To reset your menus use View, Toolbars, Customize. Then on the Toolbars tab
scroll down to Worksheet Menu Bar and select it (it is already checked).
Then click Reset. If Protection was disabled by macro this will enable it.
 
B

brett_boal

Jim -
Thank you for suggesting View -> Toolbars. It turns out the Protection
toolbar is active, but shunk and off to the side. When I expand the
toolbar I can click "Unprotect Sheet" and enter the password.
Apparently, when the Protection toolbar is active, the Protection menu
items are disabled.
- Brett
 
Top