add-in procedures called from active workbook events

[doco]

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

[Edwin Tam]

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
[email protected]
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
>
>
>

[John Green]

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" <[email protected]> wrote in message
news:%[email protected]...
>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
>