While learning a bit more about VBA I find I often have many modules open. (With just one maximised, I don't see the others accumulating). To my surprise there is no 'Close All' feature in the VBE. So I went looking for some quick way to do it and eventually found the code on this page which works a treat.

https://access-programmers.co.uk/for...d.php?t=293239

But it's a function not a macro, so I can't give it a KB shortcut for convenient use. I was hopeful that as an alternative I could add an icon to the Quick Access Toolbar, as I've just successfully done with a macro I use frequently. But I see no way to do that, as 'Functions' are apparently not in the list of options.

Can anyone help me achieve this, or some other simple way of using it please? That web article included this promising method: "Alternatively, to close all ALL windows, create an Autokeys macro shortcut for this function e.g.Ctl+Shift+X". But so far I've not found out how to do that either!