VBscript to protect Excel worksheet

[jkw2068]

Could someone show me how to use VBScript to protect a worksheet with all the properties?

(DrawingObjects:=False, Contents:=True, Scenarios:=True, Password:="password")

The only thing that works is the Password.

Any help would be appreciated. Thanks

 

[Derek Brown]

If you mean VBA instead of VBScript, then try setting DrawingObjects:=True but you may need to check the properties of the cells to make sure that they are set to 'Locked'.

 

[jkw2068]

If you mean VBA instead of VBScript, then try setting DrawingObjects:=True but you may need to check the properties of the cells to make sure that they are set to 'Locked'.

Thanks for the reply. I am actually using VBScript and invoking the Excel.Application object.

Set objXL = CreateObject("Excel.Application")

...

wrksheet.Protect DrawingObject = False, Contents = True, Scenarios = True, Password="xxx"

This will protect the entire worksheet. The DrawingObject property, no properties for that matter are being applied.

Thanks again

 

[Norie]

Is Flase a typo?

 

[jkw2068]

Is Flase a typo?

Bah. it is. Still the problem exists though.