Password protection

Expand Post »

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

Similar Threads

How to set up password to keep Windows from starting??? in Windows NT / 2000 / XP
Password protection for Website in PHP
need to access files that are password locked on old hard drive in Windows NT / 2000 / XP
Password Protection from a txt.file in HTML and CSS
?Password+Protection of External HDD? in Windows NT / 2000 / XP

grandfilth

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Sep 2005

Permalink

Apr 27th, 2006

Re: Password protection

yes as long as you know the password

need to use the following

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

rest of code

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

mrmike

Reputation Points: 11

Solved Threads: 0

Light Poster

Offline

41 posts
since May 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Huge flat file

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Language patch

DaniWeb Message

Cancel Changes

User Name
Password