- Personal macro workbook excel 2016 how to#
- Personal macro workbook excel 2016 code#
- Personal macro workbook excel 2016 download#
(If you’ve got a different version, you may need to do some secret squirrel industrial espionage via Google to get the secret plans for your particular version) Step One: Make sure the Developer Ribbon has been enabled. Note that the Personal Macro Workbook doesn’t exist until we instruct Excel to create it. (Which reminds me of another aspect of Mr Bond, but we’ll keep this family friendly for now, eh?) How do we set up our Personal Macro Workbook?
Personal macro workbook excel 2016 code#
So just like James Bond’s hidden gadgets, any code you stash in there is constantly at your command, just waiting to be whipped out and triggered at the slightest provocation. But as soon as you close those workbooks, those macros are no longer available.īut just as secret agents have briefcases with false bottoms (and possibly girls with false body-parts), Excel has a hidden workbook – the Personal Macro Workbook – that gets opened automatically any time you start Excel. So as long as you have those workbooks open, you can use those macros. But those macros are firmly attached to the workbooks they live in.
Personal macro workbook excel 2016 download#
Often on the internet you’ll find workbooks that you can download that contain useful inefficiency-killing code.
What exactly is a Personal Macro Workbook? And after that, I’ll point you to some code I’ve only just completed that could well save you hours if you use Pivots a lot.
Personal macro workbook excel 2016 how to#
Meanwhile, I’ll set the scene by showing you where and how to stash your to secret code. But don’t worry, Khushnood …your secret identity is safe with me.) So tune in tomorrow to see secret spy code in action. (Khushnood Viccaji is obviously a man with something to hide. So I told him that unless he complies by this time tomorrow, I’ll publish his real name. Which is why I asked him if to digital pen to digital paper, and share some more of his ill-gotten top secret code with us here on ExcelWikiLeaks. So in the international war on spreadsheet terror, KV’s on to something. You just need to cut and paste it into your Personal Macro Workbook and you’re on your way to world Excel Domination. Many strains of this code are highly lethal to just about any kind of inefficiency you could ever think of. Because the secret code for world Excel domination has been leaked all over the internet, by the likes of secret agent KV and 10,000 other spooks just like him. Okay, okay…so you don’t have Q at your disposal. Well…does James Bond build his own top-secret gadgets? No, of course not. Err, I mean a simple Alt + F8 to the keyboard:Īnd the best thing of all: this top secret code can be recycled over and over again, just like a James Bond plot!īut I don’t know how to write code… I hear you say. While that first point is important, that second is the clincher: code stored in a personal workbook can be unleashed with a simple judo-chop to the throat.
The Personal Macro Workbook is a secret place where you can save frequently used macros, automation snippets and code modules so that you can call them from any file and save tons of time, not to mention look dashingly good in-front of your boss. The subject of today’s post is “What would James Bond have in his Personal Macro Workbook”.