[ad_1]

Excel Macro Tips – Creating and Updating Your Personal Macro Workbook In Excel

This article will explain how to look to save your macros to a personal macro work book to re use in any work book when you start Excel on your computer.

When you create a macro in Excel it is usually designed to work in just one particular work book, but there maybe some instances where you want to use some Excel macros which are much more general, in all Excel files or at least make them available to use all in any of your Excel work books.

There is place a in Excel where you can store these macros and call on them at any time, this is the Personal Macro Work book. (PMW). This special work book is loaded up whenever you start Excel, but it does not exist in until you actually record a macro in Excel and save it in the PMW. That’s really easy to do with a few steps.

• Ensure the Developer Tab is enabled in Excel. If you cannot see it then you can easy enable it.
• Now you can record a Macro to save in the PMW. (Let’s just make some text bold in our work book).
• In cell B2 type some text – in this example I have typed Hello World.
• In the Developer Tab – Code Group – Record Macro.
• In the Macro Dialog Box, give the Macro a name- in this example I have used mytestmacro
• In the Store Macro in: select PMW..
• Hit OK.
• Hit CTRL+B to make your text bold (this is all we want to do for this small macro).
• On the Developer Tab – Code Grouping – Stop Recording.
• Close any workbooks and exit Excel.
• When prompted, save the changes to your PMW.
• Select to save the Excel file
• The next time you start Excel, your PMW will load, but it is hidden by default, but you can easily view it –
• View Tab
• Window Group
• Unhide
• You should now see PERSONAL.xlsb

Any macros you save to your PMW will be editable but only when you chose to un hide it. It is also easy to hide the PMW as well.

• View Tab
• Window Group
• Hide

If you create any new macros and save them in your PMW, or edit any macros that it contains you will again be prompted to save the workbook, just as you did the first time it was saved.

[ad_2]

Source by BJ Johnston