K
KiahM
Guest
Hello!
I've created a searchable database in Excel with user friendly search interface using UserForms. Some of the data in the database (which is hidden from user view and information only retrievable via the search form) includes information I don't want all users to have access to. I have created a separate search form from the general access user interface, that will return search results from the database with this sensitive information included, however, I want to lock down access to this search form by requiring a password which only authorised persons will be provided.
Basically, upon clicking a command button, I want the user to enter a password which, when correctly entered, launches the restricted search form.
Is there a way to do this using Visual Basic? I'm using Office 365 ProPlus.
Thanks!
Continue reading...
I've created a searchable database in Excel with user friendly search interface using UserForms. Some of the data in the database (which is hidden from user view and information only retrievable via the search form) includes information I don't want all users to have access to. I have created a separate search form from the general access user interface, that will return search results from the database with this sensitive information included, however, I want to lock down access to this search form by requiring a password which only authorised persons will be provided.
Basically, upon clicking a command button, I want the user to enter a password which, when correctly entered, launches the restricted search form.
Is there a way to do this using Visual Basic? I'm using Office 365 ProPlus.
Thanks!
Continue reading...