Is there a way to change a constant from within VB.

I know this isn't terribly secure, however it will meet my needs......

I have a workbook that is protected, with some unprotected fields. Th
protection password is declared as a constant in the AutoOpen macro ie:

Password = "1234"

I then have a lock and unlock button with macros assigned to them t
use this password to protect and unprotect the sheet.

I'd like to give the user the ability to change that password.

I know I could do this by storing the password string in a hidden shee
in the workbook, but that woudl be very easy for someone to use
different workbook to reference that sheet rom a different file and ge
the password.

So what I'd like to do is create a macros that could alter that line o
VB .....

is it possible?

Cliv

--
ccarmoc
-----------------------------------------------------------------------
ccarmock's Profile: http://www.excelforum.com/member.php...fo&userid=2767
View this thread: http://www.excelforum.com/showthread.php?threadid=53946