Hi,
in a workbook i created (actually you created most of it..) i'm using a sheet where all important data is stored (e.g. passwords)
it contains all sheet passwords and they can be modified there by the admin. now i'd like to add the password from the vba!
so lets say range("I3") contains the VBA password (the cell is named ww_vba) if someone opens VBA (ALT+F11 or through the menu) they should enter the password in cell ww_vba otherwise access should be denied!
is something like this possible?
thanx! ray:
in a workbook i created (actually you created most of it..) i'm using a sheet where all important data is stored (e.g. passwords)
it contains all sheet passwords and they can be modified there by the admin. now i'd like to add the password from the vba!
so lets say range("I3") contains the VBA password (the cell is named ww_vba) if someone opens VBA (ALT+F11 or through the menu) they should enter the password in cell ww_vba otherwise access should be denied!
is something like this possible?
thanx! ray: