Hello Excellers, today I want to show you how you how to create a shortcut to your Personal Macro Workbook. I have been asked the question a few times about the file is located (usually when users are having issues with the file) so it is useful need to know where it is located. I actually have a shortcut to mine on my machine, just in case I need it, so I thought it would be a good tip to share today.
If you want to see my other blog posts on the Personal Macro workbook you can click on the links below
- Macro Mondays -Creating and Updating Your Personal Macro Workbook
- Macro Mondays – How To Delete Your Personal Macro Workbook
- Macro Monday – Why Is My Personal Macro Workbook Not Loading Automatically?
So back to creating a shortcut- so we can have easy access to our Personal Macro Workbook. Now, where the workbook is in the first place is not the save for everybody. So, if you have read my earlier blog post above you will know that by default the workbook does not exist, until you physically create it by creating usually a quick simple Macro then choose to store it in the Personal Macro Workbook. Your workbook is now created after this process.
Now we just need to find out where it is stored and create a shortcut to it.
I have found the easiest way to see where it is stored is to look in the Trusted Location In Trust Centre in Excel, it all depends on the operating system you use (I am using Excel 2016 on Windows 8).
- Trust Centre
- Trust Settings
- Trusted Locations
You will then see a list of trusted locations. These are simply files or folders that are opened without first being scanned by the Trust Centre Security Feature.
I then took a note of the location, and simply created a shortcut in the standard way on my desktop
- Right Clicked on the Desktop
- Create – New Shortcut
- Typed the File Path or browsed to it (wither will do – which ever way ti easier for you)
- Hit Next
- Give your shortcut a name
- Hit Ok
You now have a shortcut to your Personal Macro Workbook on your desktop (or wherever you choose to put your shortcut).
If you want to see all of my blog posts in the Macro Mondays series you can find them all in the link below. Why not book mark it?, Yes it is updated EVERY Monday.
You can also download the corresponding example workbook that contains the Macro code by clicking on the download button below.