As you know, Excel files shared on a disk sometimes can be a real pain because some user opened the file and forgot to close it, making it impossible for someone else to edit it.
One solution comes in the form of creating a macro that Closes and Saves the Excel file after an Idle Time :
The only problem is that you have to add the code to every Excel file when created, and also you have to enable macros every time.
My question was if it is possible to make a code that impacts ALL Excel files. (just like when someone disables drag and drop in one excel macro, then drag and drop will be disabled for all excel files)
Thank you for your time,