Sheet Information - Is sheet protected?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Only way I know is with VBA code. If you want that method, post back and
someone will help.

Vaya con Dios,
Chuck, CABGx3
 

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

Similar Threads

Unprotect Combo Box in a Protected Sheet 3
Protecting Worksheet - Cannot move between cells. 2
CONVERTING Excel 2003 Commands to 2007 10
Can't move between cells. (Not the scroll lock) 1
allow merging cells in protected sheet 1
hide columns on a protected sheet??? 1
Protecting a Sheet 7
protect sheet macro problems 2

Back
Top