Nov 22 2022 02:44 AM
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