hi all,

i have my logins / pass and other user information (pseudo permissions) on a
sheet that will always be hidden to the user. (thought about an external file
- but decided against it, also thought about authenticating with the domain
server, but a little overkill)

i wanted to use the workbook_open event to ask for the user and password
upon open. so far this works, but i didn't want to have the passwords shown
in the code, and wanted to 'hide' where they're coming from a little better.

is there a way to define a constant range (in another module), so that i can
use that range in the workbook_open event, without specifically stating where
it is coming from? (i was thinking to use the vlookup based on
environ("UserName") to check the password agains that entered by the user)

ie i don't want to use something like

with sheets("misc")
set x =.range("logins")
end with

in the workbook_open code

any suggestions or anyone have a better idea on how to go about this?

tia!

J