Normally the approach Ron advised should work fine, but here's another way In a new instance of Excel, initiate Record a macro. In the drop-down 'store macro in' be sure to select 'Personal Macro Workbook'. Record a simple dummy macro Close Excel, accept the prompt to save your new Personal. Reopen Excel, press Alt-F11, your Personal should have automatically loaded.

It should contain one module with your dummy macro. If not, look at your security settings. Remove the module entirely (rt-click the module name) Rename your old Personal and load it. Drag all the modules from the old Personal into the new Personal. Close Excel, and accept the prompt to save Personal. Reopen Excel, a replica of your old Personal should open automatically.

Import Macros (*.bas File From Word For Mac Download

Peter Thornton.

Excel macros allow you to automate all sorts of tasks, from entering commonly used data to automatic printing and saving of files. Once you start to use Excel, it takes no time at all to create a large collection of macros for tasks you perform often. If you purchase a new computer, or if you just want to use Excel on another laptop or PC, you must save your macros in a special macro-enabled format. Once you save the macros this way, you can then move them to another computer or even email them to others so they can use them in their spreadsheets as well.