I have a workbook that I don't want anyone else to print except the supervisors. I have a list of those supervisor's ID's in a range on a tab in the workbook.
All of our users have to sign into the computer using their ID.
I am looking for some code that will compare the user sign on to the ID's on the range of supervisor ID's and print ONLY if it finds a matching ID. Otherwise, show msgbox that says printing is not allowed.
Any help would be greatly appreciated!
All of our users have to sign into the computer using their ID.
I am looking for some code that will compare the user sign on to the ID's on the range of supervisor ID's and print ONLY if it finds a matching ID. Otherwise, show msgbox that says printing is not allowed.
Any help would be greatly appreciated!
