What I am trying to do is when a workbook is opened check against a list of authorized users before opening. And I go this working already. The next step - if possible - would be if they are not on that list open a copy of the workbook in a state WHERE THEY CAN NOT SAVE OR SAVE AS and close the original work book.
Is this possible?
Is this possible?