Hi All,

I'm just new on this forum and new with VBA coding as well.

I tried to secure a .xlsm file which is posted on the server as ReadOnly to avoid distribution of the file to other locations. (Copy Paste of the file to another folder is possible)

So I tried a VBA codes which does check if the path (FileFolderExists) is existing, when not it should not open the file but I can get this working prior opening the file (only as macro).

Are there any other smart VBA methods to secure the file to avoid distribution of the file to a different location?

Many thanks for your support.

Juri