I've had some assistance with an Excel report where access to the report is governed by a VB login box.
The code for the login functionality works as it should, but I now need to amend this somehow to pass the "logged-in" user to a cell in one of the spreadsheets. I'll then use IF statements and VLOOKUPS to dictate the data that the user will see relative to their Username, referencing this cell value.
I'm by no means a VB expert, so I'd very much appreciate some assistance with amending the following code in order to achieve the above. If separate code (for a separate spreadsheet) is required, advice for this would also be appreciated!
Form:
"ThisWorkbook"
I'm under a bit of pressure at work to get this done, so some expert advice would be great!
Bookmarks