VBA Worksheet Protect

[rdsouza]

Dear All

I have the following code that removes the protection from a worksheet and after performing a delete of certain cells protects the worksheet again. This code does not work when the worksheet is protected with a password. The password to the worksheet is the letter "a". How can I include the password in the code so that the protection is removed before the delete action and reinstated after the delete action


ActiveSheet.Unprotect
Range("C95:N95").Select
Selection.ClearContents
ActiveSheet.Protect

Thanks
Rodney Dsouza

[JBeaucaire]

Please edit your post above to include code tags, like shown below.

No need to unprotect, just give the macro permission to edit the protected sheet by setting the UserInterfaceOnly flag.

Please Login or Register  to view this content.