Protected Objects

[rgandy]

in password protecting a sheet, what property must i access to unprotect an object so that it may be changed even if the remainder of the sheet is password protected?

 

[rmikesmith]

Protect your worksheet via code using the something like the following:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, [b]UserInterfaceOnly:=True[/b]

This will allow your procedures to manipulate worksheet objects with protection in place.


Regards,
Mike

 

[rmikesmith]

I should have added that the line of code to protect the worksheet should be located in the Workbook_Open event procedure so that it runs every time the workbook is opened. This is necessary because the protection is transient, unlike when invoked through the UI. Your other options are to not protect for Drawing Objects or to have your code turn off sheet protection/manipulate the objects/restore sheet protection.


Regards,
Mike