Hi John. Thanks for the tips. Worth mentioning that a quick way to make the change, assuming you have the Developer tab enabled, is ALT, L, AS which takes you directly to the Trust Center and Macro Settings tab. Thumbs up!
I there no way to auto enable them when user downloads the template from our application??? ....i am a developer i have developed macros based template but after Downloading template macros are not getting auto enabled.
I don't know of a way of doing this directly...but I have a work around on this video here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-z7nZA0c88Wc.html
👉 Up4Excel Downloads Library: »» ml.up4excel.com/library ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
You should be able to use this technique to enable them. If you are in a corporate office sometimes the system admin switches the options off though....you'd have to request access in this case.