Hello
I'm not sure if this is even possible but thought I'd put it out there in case you experts knew how. I basically have an Excel document which has very sensitive information. Just password protecting it isn;t enough as the password might be shared by users. What I would like to do is create a master list of user names (ideally using their email addresses as this will ensure unique entries) and only those users will be allowed access to the spreadsheet. Only I will have access and right to edit this master list and adding or removing a name from this list will change access rights for those users automatically, for this document. Is there any way i can do this using VBA? The spreadsheet itself has no code in it and is such a simple table with data.
Thanks!
Bookmarks