How to find properties of an object

[ammiller]

Hi,

I am trying to determine if a worksheet is protected.
The worksheet in question is in a multi worksheet workbook.
It is also the active worksheet.

I tried looking at the "activesheet" properties - but cannot find a definitive list. I stumbled across one called "protectionmode" but that seems to return "false" whether or not the worksheet is protected.

Is there a way in the VBA help I can find the definitive list of properties of an object?

Thanks

Aidan

 

[RobBroekhuis]

Activesheet is an object of type "worksheet" (or "sheet&quot. If you look up "worksheet object" in VBA help, you'll have a help item listing all the properties. That works for any Excel object type, not just worksheet.
Rob

 

[ammiller]

Thanks Rob.

 

[Nikita6003]

Aidan,

check out the object browser as well ... press [F2} & it'll appear. You can enter a keyword in the search box, & all objects with your keyword as part of their name will appear. makes it easier to look, because once you've got the proper VBA name it's easier rto search VBA help

As for checking whether a worksheet is protected - use something like this:

Dim l_wksSheet As Worksheet
Set l_wksSheet = ThisWorkbook.Sheets(1)
MsgBox "Protection = set to: " & l_wksSheet.ProtectContents

Yuo've got 3 of these readonly boolean worksheet properties:

ProtectContents
ProtectDrawingObjects
ProtectScenarios

For workbook protection use

ProtectWindow
ProtectStructure

Hope this helps

Cheers
Nikki