Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add-in procedures called from active workbook events
I have a procedure I wish to place into an add-in - simple enough done.
However, when this add-in is instaced I want this procedure to be called from *any active* workbooks' Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) event. How is this done? TIA doco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add-in procedures called from active workbook events
The syntax for calling a macro in another file (no matter xls or xla) is:
Application.Run Macro:="'file_name'!macro_name" But you won't be able to call the "Workbook_SheetSelectionChange". You probably need to pull the code onto a separate Sub in a module. Or, you can use a Sub in a module which executes the "Workbook_SheetSelectionChange". Regards, Edwin Tam http://www.vonixx.com "doco" wrote: I have a procedure I wish to place into an add-in - simple enough done. However, when this add-in is instaced I want this procedure to be called from *any active* workbooks' Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) event. How is this done? TIA doco |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
add-in procedures called from active workbook events
You want to trap Application events. This can be done using a class module.
The procedure is outlined on Chip Pearson's website: http://cpearson.com/excel/AppEvent.htm John Green "doco" wrote in message ... I have a procedure I wish to place into an add-in - simple enough done. However, when this add-in is instaced I want this procedure to be called from *any active* workbooks' Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) event. How is this done? TIA doco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow to Open, Small Workbook <2MB, HTML Paste, VBA procedures | Excel Discussion (Misc queries) | |||
Running procedures on events xl2003 | Excel Programming | |||
Worksheet_Activate Not Called When Opening Workbook | Excel Programming | |||
two procedures in the same sheet one a workbook even procedure | Excel Programming | |||
Mouse over events for Active X objects in excel | Excel Programming |