how to make my macro available in all excel workbooks

We need to start off the macro by inserting a New Module.

Why Is My Personal Macro Workbook Not Loading Automatically? Starting The Macro Macro Mondays – Create A Shortcut To Your Personal Excel Macro Workbook Macro Mondays -Creating and Updating Your Personal Macro Workbook

If you want to read more about your Excel PMW then check out my blog posts below. Learn More About Your Personal Macro Workbook (PMW) Therefore I will create and save this macro for future use in my Personal Macro Workbook. If you store it in the current workbook then use is restricted to that workbook.Īs you can see this macro will be useful to reuse in any workbook with links that require analysis. If you save the macro in your Personal Macro workbook it will be available for use in any of my Excel workbooks. You then have a choice, you can either create a module to store your code either in your Personal Macro Workbook or in your current workbook. Either by hitting ALT +F11 or selecting the Developer Tab | Code Group | Visual Basic. If your links are broken are have issues then Excel will display the dialog box below.įirst, you will need to open the Visual Basic Editor. This is especially important if the links are generating an error when the workbook is opened. By generating a list on a new worksheet with a small bit of VBA code allows me to analyse the links much easier and trace the source. I find that if there are a large number of links in a workbook, the manual method is hard to read and work with. Writing A Macro To Display Excel Workbook Links Just follow the steps below.Įxcel will display a dialog box and list your external data sources. Want To Use A Manual Method Of Displaying Links?.īefore we get started on an automated solution to this problem, I want to point out that you can of course view all of your links in your workbook using the worksheet menus. This sounded like a job for some VBA code. Multiple workbooks contained multiple links. Multiple old links in Excel worksheets were now displaying errors when trying to update links.

I recently wrote this code to use in the past few weeks as due to some changes at work. Today’s small but very useful Excel macro will list any links that you have in your Excel worksheet. Hello Excellers and welcome back for another blog post in my #macromonday series.

How to make my macro available in all excel workbooks