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) :
GOAL/problem:
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...
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: