Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I run a macro in an xla from a button on a sheet
I want buttons on worksheets in my workbook to run a macro that is
stored in an add-in I have called the macro 'Public Sub xxx()' I have created a reference to the add-in in the workbook that will have the buttons. But I can't 'see' the macros in the add-in to be able to assign them to the buttons. Can I do it? how? Cheers Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I run a macro in an xla from a button on a sheet
There are two ways to call procedures in other workbooks (incl addins).
First was is to set a reference (tools, References) to the project name (be sure to have changed from the default VBAProject. But for your needs probably better to use the Run method (though you won't get any intellisense) ret = Application.Run("myAddin.xla!moduleName.ProcName") you can also include arguments. Regards, Peter T "Michael" wrote in message ... I want buttons on worksheets in my workbook to run a macro that is stored in an add-in I have called the macro 'Public Sub xxx()' I have created a reference to the add-in in the workbook that will have the buttons. But I can't 'see' the macros in the add-in to be able to assign them to the buttons. Can I do it? how? Cheers Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy a sheet and delete a macro button | Excel Programming | |||
Macro Button in a work sheet | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
Macro button on one sheet only | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming |