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")