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...
yes as long as you know the password
need to use the following
Sheets("sheettounprotect").Unprotect ("password")
rest of code
Sheets("sheettoprotectagain").Protect ("password")
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.