remember password for excel 2010 in vba userform

[murray83]

i have the following code which works fine

Please Login or Register  to view this content.

and allows them to view the admin area of the workbook, but if they click back onto the main search page the tab is hidden again and can only be got to again by re-entering the password

can i store the password until the workbook is closed so that you only have to enter it once

cheers all

[buran]

You need to make password variable global, i.e. declare it at module level - either normal module or userform module - it's not clear if this code is in userform module or in worksheet module. If this code is in UserForm - then declare it there, i.e. look for the narrow scope possible.
Eventually you may need to change the workflow/code for getting the password for the first time / request password again of for some reason it has been changed and no longer valid.