change password
 

Hi

i have coded a spreadsheet and locked the vba properties.

The spreadsheet has 2 textboxes which are unlocked by a
button followed by the user entering their name and
password on a form.

Is there anyway I can by means of a userform, allow the
user to change his/her password without me having to go
into the code and change it there?

Many thanks

change password
 

Libby,

Changing the password in the hard coded VBA can be done
but it would probably be a nightmare to do it.
If you really want to go that route, here's a start:
http://j-walk.com/ss/excel/tips/tip61.htm

What might be easier is to save the ID's and passwords
on a VeryHidden sheet and then you could write code
to allow the user to change it.

I have an example of a workbook (it's actually two) where
only the ID's and passwords are saved in one and the
other one (main workbook) checks for the correct ID's
and passwords when you try to open it.
I use this method for "attempting" to protect multiple
workbooks and not having to change each and every one
of them when an ID or password needs to be changed.
If you send me a direct e-mail, I'll forward you those
workbooks.

John

"Libby" wrote in message
...
Hi

i have coded a spreadsheet and locked the vba properties.

The spreadsheet has 2 textboxes which are unlocked by a
button followed by the user entering their name and
password on a form.

Is there anyway I can by means of a userform, allow the
user to change his/her password without me having to go
into the code and change it there?

Many thanks