Process to aid in enabling macros & sync SharePoint folders

[gravanoc]

I have built a workbook that is intended for wide distribution in the office, so I'd like to make the initial setup as painless as possible to ensure the tool is adopted. To do this I need an external executable of some sort that can guide the user through the setup or even do it for them if they consent. It would then automatically enable macros for this workbook, trust the VBA object model (if necessary), and sync the folders containing the auxiliary files that the tool uses: e-mail templates, pictures, etc. I have found a kind of general walkthrough for the syncing part here: Configure team site libraries to sync automatically, but it doesn't really seem aimed at the programming aspect.

Obviously enabling macros for the user without their permission would be shot down by security, so if the user intends to run this executable, they would already know what it does. That means it doesn't need to have any GUI or whatever, just a simple double-click program that will check all the boxes above. However, I would also be fine if it were something that simply walked the user through, step-by-step, how to turn on the relevant settings. Thanks for any suggestions!

 

[GWteB]

It would then automatically enable macros for this workbook, trust the VBA object model (if necessary),

This is not possible, luckily. Had this been possible, this form of security would have been useless beforehand.

Would suggest to "elevate" a worksheet to a splash screen (while at the same time all other worksheets are hidden...), informing the user what the desired settings of the security center should be. When macros are enabled, then your code is able to make all relevant worksheets visible and to hide the splash screen.