themroc
asked on
How to invoke Subroutines/Macros from an xla file in an Excel sheet
I I created an add in file (xla), which is always opened when I run Excel.
Here I have got different functions which are available for all worksheets open.
Now I recorded a marco and i put the result also in the xla file.
I declared the subroutine public
When I now go to
/Tools/ Macro / Macro
I do not find this Macro Name in the list, even i choose look in all open workbook.
What do I have to do to acces a macro in a xla file???
Here I have got different functions which are available for all worksheets open.
Now I recorded a marco and i put the result also in the xla file.
I declared the subroutine public
When I now go to
/Tools/ Macro / Macro
I do not find this Macro Name in the list, even i choose look in all open workbook.
What do I have to do to acces a macro in a xla file???
Rory Archibald
You can run it by typing the macro name into the dialog, but usually routines in an add-in need a menu (button on a toolbar) to run them. They do not show up in the macros list.
ASKER
How do i create a menu button or perhaps better a list entry/
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What did you mean by "perhaps better a list entry"?
ASKER
I have seen add in files when ticked they create an entry with a specific name under tools in the excel menue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.