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

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

"ccarmock" wrote in
message ...

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. The
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 to
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 sheet
in the workbook, but that woudl be very easy for someone to use a
different workbook to reference that sheet rom a different file and get
the password.

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

is it possible?

Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile:
http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=539462

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

--
Regards,
Tom Ogilvy

"ccarmock" wrote in
message ...

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. The
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 to
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 sheet
in the workbook, but that woudl be very easy for someone to use a
different workbook to reference that sheet rom a different file and get
the password.

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

is it possible?

Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile:
http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=539462