Macro available in all workbooks
Hi, Dave - your answers are really great and I'm learning a lot from them.
I had a workbook with macros to which I was always navigating.
I did Save As: Type: xla: "[Bod Macros].xla" and XL took me to the Add-Ins
folder, so I saved it there.
How do I now make myself a wee button to be able to choose which macro from
that book I want to run (maybe I should be using a xlb or an xls).
I don't quite get the which I would want to use out of xls, xla and xlb.
When I just saved my macros in a xls file in XLStart, that book opened up
every time I ran XL, but I don't want that as I don't ALWAYS use the macros -
I just want them to always be available (unless if I don't have that option).
|