Change a constant from VB

[ccarmock]

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

 

[Robin Hammond]

As far as I am aware a constant is just that, and once your code is running,
any attempt to change it should fail.

Why not encypt the password in some way and store it in the registry?

Have a look at SaveSetting in the help files.

Robin Hammond
www.enhanceddatasystems.com

 

[Tom Ogilvy]

If your not going to lock your project, then it would be even easier to look
in your code to get the password. If you do lock your project, then you
won't be able to alter it with code. Also, in later versions of excel, the
user has to allow code to have access to the vbe.

http://www.cpearson.com/excel/vbe.htm