enable personal macro workbook excel 2016 mac

To the current name and you only need to edit the time.įorgot to include the Screen Shot so here it is. I usually use a date and time in the version name like the following because y/m/d dates with 2 digit months and days will sort well. Microsoft has stated that the Mac version will have feature parity to the Windows version. Where VBA was completely unusable three months ago, now you can write simple macros. In some ways, it's still a beta version and every update adds significant new features.

I saveĪ version at least every half hour or so and again immediately before testing the VBA code. Excel 2016 is a complete rewrite of the Mac version of the program. It is not unusual to lose a workbook by corruption simply because the developer has done something wrong in the VBA code. With all projects that take a lot of time you should save versions of the workbook so you can go back if you have a problem. If it really does not matter if macro enabled then I leave it as macro enabled.Then if you don't want a macro enabled then change it during 'Save as'.Set Save option as per the screen shot below.Choose to Store Macro in a Personal Macro Workbook so that the macro can be used across your Excel documents (old and new). However, I use the following procedure to ensure that I do not lose macros by having the default save as macro enabled and if I don't want it macro enabled then change it during the Save as. Click the Record button, and Excel will display the Record Macro dialogue If you would like to assign a shortcut key to your macro, enter in a number, letter, or symbol next to Option+Cmd+. I am not aware of a method of recovery of the macros. I can't be sure how you lost your macros but I am speculating that maybe you used 'Save As' and was not paying sufficient attention to the prompts and answered incorrectly to save without macros.

Enable personal macro workbook excel 2016 mac