I have created a UserForm that, when run, does the following:
- copies an existing template onto a new worksheet
- renames that worksheet to match the EmployeeName (that was entered on UserForm)
- on an existing worksheet, named SnapShot, inserts a row
- in Cell "B41" copies that same EmployeeName.
What is the code to make "B41" automatically hyperlink to the newly created sheet?
I would like this code to be the final step when the userForm is run.
Thank you for your help,
John
Bookmarks