Stop an excel workbook or worksheet from opening if workbook isn't in a certain folder

Hello All,

Is there anyway to write some VBA code to prevent a workbook from being opened if has been moved or saved to a different folder location. The reason is to prevent people from saving the certain document to a different location, so there can only be one copy available.

I have added in macros to prevent saving and there are macros included to save a shortcut to the users desktop so there is no need to make a copy, these work quite effectively, but the only issue is if someone doesn't allow macros to run then the document can be saved regardless of the macro preventing saving.

So would such a macro be possible to check, if the workbook isn't located in e.g. C:/test then it will give an error message saying please use original workbook.

Any help would be much appreciated.

Thanks very much,

Paul