Store password while the sheet is open

[murray83]

been looking into this and have seen that i need to declare it in module or put it in work sheet load

my question i would like answering is

in the example attached when you click on "Amend User Details" it pulls up a userform asking for a password which is at the moment set to "PASSWORD" original i know

when this is done the database sheet is shown and then when they click back to search it hides but if you need to Amend User Detail again it needs the password

i would like it so its stored for the life of the workbook being open

cheers all

[Logit]

.
.
Try this approach...

Paste this macro into the Sheet Database level module:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi

Pick a cell on a hidden sheet. I used R1 on the Database sheet but probably best if you just add a sheet solely for the PW and NAME it "PASS_Word"

Then change the Add_Details to

Please Login or Register  to view this content.

In the Userform CommandButton1 click event use this code

Please Login or Register  to view this content.

And in the Workbook Save Event add a line

Please Login or Register  to view this content.

[murray83]

Thats one option cheers

But would rather have the sheet hidden but when press the button again no need for password

Richard Buttrey shall check yours out as well

cheers guys

[Richard Buttrey]

..in case you missed a late edit I changed #3 - forgot to mention to create the range name

[murray83]

Hi

Pick a cell on a hidden sheet. I used R1 on the Database sheet but probably best if you just add a sheet solely for the PW and NAME it "PASS_Word"

Then change the Add_Details to

Please Login or Register  to view this content.

In the Userform CommandButton1 click event use this code

Please Login or Register  to view this content.

And in the Workbook Save Event add a line

Please Login or Register  to view this content.

dumb moment me thinks but here goes

1, How do i make R1 on the database sheet into a range ?

and

2, "Workbook Save Event" i dont even have a function like this

[murray83]

ignore the how make a range name

good ol google

[murray83]

any chance of an example of this uploaded

[Richard Buttrey]

See attached,

The Workbook BeforsSave event is an event in the ThisWorkbook object in the VBA Workbook

[Logit]

.
.
This is the only change I would recommend to the existing I posted :

Please Login or Register  to view this content.

[murray83]

See attached,

The Workbook BeforsSave event is an event in the ThisWorkbook object in the VBA Workbook

Thank you works a charm just made one slight change rather than just leaving the sheet open now if you click it, it takes you to the sheet

see attached