0

I wish to password protect my worksheet. However, I have some Macros which have to unprotect the sheet in order to add a text box and then protect the sheet again. Is it possible to unprotect a password protected sheet?And then password protect it again after the object has been added?

Any help would be much appreciated...

2
Contributors
1
Reply
2
Views
12 Years
Discussion Span
Last Post by mrmike
0

yes as long as you know the password

need to use the following

Sheets("sheettounprotect").Unprotect ("password")

rest of code

Sheets("sheettoprotectagain").Protect ("password")

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.