XLSTART / Distributing macros

waterbottle2

New Member
Joined
Jun 15, 2015
Messages
25
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!
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

waterbottle2

New Member
Joined
Jun 15, 2015
Messages
25
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,573
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top