App_SheetSelectionChange

[Phil Bewig]

I have an add-in that needs to use App_SheetSelectionChange.

However, I am somewhat worried about the cost of using A_SSC.
What exactly is happening when A_SSC is active? Does A_SSC
hook an interrupt somewhere? Or is something being continuously
polled? What happens when I close the add-in? And where can I
find documentation of exactly what is happening?

Simple experiments haven't shown any cost to using A_SSC. But
what happens when my add-in is called with very large spreadsheets?

Thanks for all help.

Phil

 

[Tom Ogilvy]

You event is called everytime a new cell is selected on any open workbook.

If your event code is fast, you should see little effect. the size of the
spreadsheet shouldn't have any effect on the firing of the event - if the
code in the event loops through every cell on the activesheet.usedrange or
something like that, then you might have a problem with larger sheets.