Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet/workbook protection property?
Hi
I need to find out whether a spreadsheet is protected at worksheet and/or workbook level. I can't find a property which will tell me this - the protect/unprotect methods will add or remove protection but how can i find out without actually doing this? thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet/workbook protection property?
go to the object browser and select the Excel library, search term protect.
Scroll through the objects. You will see properties like ProtectStructure, ProtectWindow (workbook level protection), ProtectContents, ProtectScenario, etc for sheet level protection. If one of these are true, that particular aspect is protected. Regards, Tom Ogilvy "brian" wrote in message om... Hi I need to find out whether a spreadsheet is protected at worksheet and/or workbook level. I can't find a property which will tell me this - the protect/unprotect methods will add or remove protection but how can i find out without actually doing this? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a rental property worksheet template in Excel? | Setting up and Configuration of Excel | |||
looking for a rental property expense income worksheet | Excel Worksheet Functions | |||
Property Analysis Worksheet | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
DisplayGridlines should be a property of Worksheet class, not Wind | Excel Discussion (Misc queries) |