Only way I know is with VBA code. If you want that method, post back and
someone will help.

Vaya con Dios,
Chuck, CABGx3



"lbit" wrote:

I know you can use cell information to determine if a certain cell is locked
or unlocked. Is there a similar formula that can tell you whether a
specified sheet is protected or unprotected? I maintain over 30 models and I
wnat to make sure I remembered to protect all of the sheets and I'd hate to
open each model to manually check. Thanks!