XLSTART / Distributing macros

[waterbottle2]

Hey there. I was wondering if XLSTART could be used as an effective way to distribute macros to someone who doesn't know Excel VBA. I tried saving the macro workbook as an Add-In file, but I was having trouble getting the macros to appear in a new workbook (even with the add-in installed).

Is there any way to get an xls* file placed in XLSTART to behave like the personal macro workbook (only opening in the background)? It'd be really easy for me to distribute the macros that way, but I'd like Excel to open to a blank workbook upon start (rather than my xls* file).

Thanks either way!

 

[waterbottle2]

I found a satisfactory solution. The macros in my add-in don't appear in the Developer tab under "Macros", but It seems that I can add the macros from the Add-In to my Quick Access Toolbar. To do this:

Install and activate the add-in. Go to Excel Options -> Customize. Under "Choose commands from:" I change "Popular Commands" to "Macros". There you will see the macros in the Add-In. Select one of them, and click the "Add>>" button to add them to your quick access toolbar. Select the macro and click "Modify" to change the image associated with your macro. Click "Ok" to confirm your changes. You should now see your Add-In macro in the Quick Access Toolbar at the top of the Excel window.