Robert_Conklin
Board Regular
- Joined
- Jun 19, 2017
- Messages
- 173
- Office Version
- 365
- Platform
- Windows
- MacOS
I currently have a command button on my userform for the user to "SUBMIT" the data that they entered. This command button pushes the data entered to other worksheets where the data is pertinent. I want to create a "REVIEW" button for the person that is approving the data to use. When clicked, I would like the macro to take them to the data sheets that the "SUBMIT" button sent the data to so they can verify and approve the data accordingly. Here is the catch, the review button should only work if the Windows username matches those specified in the code. Similar to the way my code is written to automatically unprotect all of the sheets based on username. Any help would be greatly appreciated!