| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Information - Is sheet protected?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheet Information - Is sheet protected?
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically get information from sheet 1 into sheet 2 | Excel Discussion (Misc queries) | |||
| Protected Sheet doesn't update linked information | Excel Discussion (Misc queries) | |||
| Reference information from one sheet to a second sheet | New Users to Excel | |||
| Protected sheet to unprotected sheet | Excel Worksheet Functions | |||
| protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
