Need Help to enable macro for all the users in the organization

Copper Contributor

Hi all, 

 

I have used a VBA code to disable save and save as option. It is working fine in my local drive after giving trusted path. But I want to transfer the file-to-file server, and i want the macro to run for all the users who open the file. 

 

I tried giving server path as trusted location, it's not working. Please give suggestions.

 

 

Also, is there any way to disable save, Saveas and options settings in excel using VBA code. Thanks in advance

0 Replies