Pat_The_Bat
Board Regular
- Joined
- Jul 12, 2018
- Messages
- 83
I've been working on a very useful tool for my team at work. One of my concerns is that I don't want this tool to be shared with competitors, and/or if a current employee leaves, I don't want them taking it with them.
We operate in a cloud environment, so my thought was to run a macro upon opening the workbook that automatically checks for a certain file on the server somewhere, and if it finds that file, then the user can continue.
If not, then the workbook closes.
Or even check that file for an authentication code, and if passes, go ahead, if can't find the auth code, then workbook closes.
Can this be done? Is there a better way of handling? I'm open to suggestion!
We operate in a cloud environment, so my thought was to run a macro upon opening the workbook that automatically checks for a certain file on the server somewhere, and if it finds that file, then the user can continue.
If not, then the workbook closes.
Or even check that file for an authentication code, and if passes, go ahead, if can't find the auth code, then workbook closes.
Can this be done? Is there a better way of handling? I'm open to suggestion!