I want to create a VBA macro that will do the following:
The Excel file with the Macro should only open when the file is opened from a certain folder in the Windows directory.
If it is not opened from the specified folder, it needs to show an error msgbox and close the file automatically.
The file we're using is already completely secured however users can still copy it from the existing folder to their desktop for example, we want to prevent them from using an older version by only accepting the opening of the file from a certain directory. I've tried looking around the internet for a solution but did not find it.
Opened from includes shortcuts.
It is a corportate file but macros are used in our environment.
I need code where I can edit the folder name to be anything I want
(so we can always change it later)
No comments:
Post a Comment