I've been tasked with creating an Excel-based report that will be sent to a number of individual business partners, but rather than send a number of separate versions I'd instead like the data included within to be governed by a Username and Password login form.
The form itself will only dictate access to the report. I can amend the data available to the user with VLOOKUP's etc. provided that this can reference a cell which shows the 'logged-in' user.
I have little-to-no VBA programming experience but am under some pressure to produce the report in this way. With this in mind, I'd very much appreciate some assistance with the following:
Providing the relevant code that will allow me to create a Username and Password form, where Usernames and Passwords are stored (by me) in a separate "Very Hidden" sheet. The 'logged-in' user should be stored in a cell on a hidden sheet - potentially the one containing Usernames and Passwords for ease.
Any assistance you can provide would be much appreciated.
The form itself will only dictate access to the report. I can amend the data available to the user with VLOOKUP's etc. provided that this can reference a cell which shows the 'logged-in' user.
I have little-to-no VBA programming experience but am under some pressure to produce the report in this way. With this in mind, I'd very much appreciate some assistance with the following:
Providing the relevant code that will allow me to create a Username and Password form, where Usernames and Passwords are stored (by me) in a separate "Very Hidden" sheet. The 'logged-in' user should be stored in a cell on a hidden sheet - potentially the one containing Usernames and Passwords for ease.
Any assistance you can provide would be much appreciated.
