Hi all

I am using the Workbook_SheetSelectionChange event to determine when a range is selected and to show the total, average and number of items selected. This works great in a workbook, but I have tried to set this up in an add-in so it's availale all the time, but it doesn't work because the event is tied to the add-in file and not the currently active workbook.

Does anybody know of a way around this?

Thanks

DJB