adding excel file in add-ins custom toolbar

excel length

New Member
Joined
Jan 29, 2013
Messages
19
I want to add my excel file with macro to add-ins custom toolbar.

my excel file (myfile.xlsm) :
- contains many subroutines and events like workbook_open
- contains activeX
- has lots of predefined worksheets.

GOAL/problem:
after converting myfile.xlsm to myfile.xlsa my goal is:
1. when I click myfile.xlsa it will be automatically added to the custom toolbar when I open an excel file
- this I dont know how

2. this add-in SHOULD NOT run yet but available in toolbar when I open an excel file
- myfile contains workbook_open event (I tried to "install" myfile.xlsa to my add-ins but it automatically runs even if I dont need it)

3. when I click this toolbar it will open myfile.xlsm(or myfile.xlsa) as a different workbook and MUST NOT affect the current opened file.


In short basically,my goal is opening the "myfile.xlsm" through add-ins custom toolbar. Instead of opening myfile.xlsm directly I want it to be "hidden" in the add-ins folder.
I hope somebody can give me some codes or files or maybe at least one from the 3 above.

I had this kind of add-ins once (not my file, can't find it anymore), when I opened the file it had been automatically added to my custom toolbar.

I can "install" add-ins manually for some simple macro but with this case,
I've been searching for sometime now yet cannot find a right code for a complicated macro.

i am using excel 2007.

Thanks...
 
Last edited:

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,215,460
Messages
6,124,949
Members
449,198
Latest member
MhammadishaqKhan

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
Back
Top