View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Bod Bod is offline
external usenet poster
 
Posts: 17
Default 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).