| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking with code to see if a Workbook is Protected?
Hi Everybody,
I'm looking for a method or property (if exists) that will allow return a Boolean as to whether a Workbook is currently protected or not? Thanks for any help! Sam P.S. I'm working with Excel 97 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking with code to see if a Workbook is Protected?
Try this Sam
Sub test() If ActiveWorkbook.ProtectStructure = True Then MsgBox "The ActiveWorkbook workbook is protected" End If End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "debartsa" wrote in message ... Hi Everybody, I'm looking for a method or property (if exists) that will allow return a Boolean as to whether a Workbook is currently protected or not? Thanks for any help! Sam P.S. I'm working with Excel 97 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking and Unchecking CheckBoxes in code | Excel Discussion (Misc queries) | |||
| RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
| Spell checking a protected worksheet | Excel Discussion (Misc queries) | |||
| How can I use spell checking in a protected worksheet? | Excel Worksheet Functions | |||
| Color Code Date Checking | Excel Worksheet Functions | |||
Hybrid Mode
