Excel for mac vba filesaveas3/16/2024 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
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |