It appears that MS Excel opens macro-enabled workbooks in one of three ways:
(1) A pop-up bar that includes an "Enable macros" button;
(2) A pop-up dialog box that includes an "Enable macros" button; or
(3) No pop-up at all with a hidden "Enable Content" button maddeningly hidden within the "File" menu under the "Info" section.
Is there any way to force Excel to use a pop-up notification that always allows the user to automatically enable macros with the convenient click of a button? This is especially critical given that I have macros that run automatically when the workbook opens. However, under the third option mentioned above, the user would never know to click the "Enable Content" button in the File>Info menu.
Any help would be greatly appreciated!
(1) A pop-up bar that includes an "Enable macros" button;
(2) A pop-up dialog box that includes an "Enable macros" button; or
(3) No pop-up at all with a hidden "Enable Content" button maddeningly hidden within the "File" menu under the "Info" section.
Is there any way to force Excel to use a pop-up notification that always allows the user to automatically enable macros with the convenient click of a button? This is especially critical given that I have macros that run automatically when the workbook opens. However, under the third option mentioned above, the user would never know to click the "Enable Content" button in the File>Info menu.
Any help would be greatly appreciated!