Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Add-In Macro from VBA
I created a simple add-in that contains one module (module1) and that module1
contains a simple macro (macro1). I posted that add-in to a file folder on my desktop and then added it to my Excel Application. So, if I look in the VB Editor I can see the new .xla as a separate project in every Excel Workbook I open. QUESTION: I can attach that .xla macro1 to a toolbar command icon (and it works). I can also attach it to a simple Excel 'Button' and that works, too. But when I insert a VB command button into a worksheet, and then add a simple procedure to the click event, I cannot get the .xla macro to run. What is the proper syntax? The following (or any other longer syntax I use) doesn't work: Private Sub CommandButton1_Click() Macro1 End Sub Thanks, wcm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
Excel Macro call Word Macro with Parameters | Excel Programming | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming | |||
ONe Macro won't call another | Excel Programming |