I have been successfully using the Workbook_BeforeSave macro to ensure that users of my workbooks always save as a macro enabled workbook.
This works fine when the user presses the "Browse" button, or the "More options..." link on the Excel 2016 File/Save As page.
However, it is also possible to modify the current file name in the text box at the top of the Save As page, then when the adjacent "Save" button is pressed, my macro is called. But the prior user modifications do not seem to be available at that point, so when I pop up the "GetSaveAsFilename" dialog with the ".xlsm" file options set, the user must repeat their modifications, which gets frustrating.
Can anyone suggest a workaround?
This works fine when the user presses the "Browse" button, or the "More options..." link on the Excel 2016 File/Save As page.
However, it is also possible to modify the current file name in the text box at the top of the Save As page, then when the adjacent "Save" button is pressed, my macro is called. But the prior user modifications do not seem to be available at that point, so when I pop up the "GetSaveAsFilename" dialog with the ".xlsm" file options set, the user must repeat their modifications, which gets frustrating.
Can anyone suggest a workaround?
