Back to Blog
Excel for mac vba filesaveas7/11/2023 Then double click ThisWorkbook under the VBAProject section to open a new blank module, and then copy and paste the following code into the module: Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. ![]() To save the workbook as macro enabled workbook by default, the following VBA code may help you, please do as this:ġ. How could you force users to save as a macro enabled workbook?įorce users to save as a macro enabled workbook with VBA code To keep the codes, you should save the workbook as Excel Macro-Enable Workbook format. When you save an Excel workbook, it will be saved as xlsx file format by default, and this file format will get rid of the macro codes from the workbook if there are multiple codes. How to force users to save as a macro enabled workbook?
0 Comments
Read More
Leave a Reply. |