DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Password protection

•

Join Date: Sep 2005

Posts: 16

Reputation: grandfilth is an unknown quantity at this point

Solved Threads: 0

grandfilth grandfilth is offline

Offline

Newbie Poster

Password protection

Apr 21st, 2006

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...

•

Join Date: May 2005

Posts: 41

Reputation: mrmike is an unknown quantity at this point

Solved Threads: 0

mrmike

Offline

Light Poster

Re: Password protection

Apr 27th, 2006

yes as long as you know the password

need to use the following

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

rest of code

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