I am using Excel 2002 for Windows. I can look at my toolbar and see if
a cell is protected by looking at the "lock cell" icon. But the only
way I know to determine if a sheet is protected is to either click the
"Protect Sheet" icon, or type something in a protected cell and seeing
what happens. Is there a way to just see, at a glance, if a sheet is
protected, as you can when a cell is protected?
Thanks
Tonso
T. Valko - 13 Jul 2007 22:11 GMT
Depending on what options have been applied when setting the protection,
usually most of your toolbar buttons will be dimmed ("grayed out").

Signature
Biff
Microsoft Excel MVP
>I am using Excel 2002 for Windows. I can look at my toolbar and see if
> a cell is protected by looking at the "lock cell" icon. But the only
[quoted text clipped - 6 lines]
>
> Tonso