Little_pea
06-23-2008, 12:35 PM
I have a spreadsheet (call it SS.xls) with a number of sheets (called, eg, "Notes","Archive"), and a separate add-in.
I want to have some code in the add-in that is called when one of the sheets is activated. (separate modules for each of the sheets)
Of course, I could have some code in SS.xls, but I want it all in the add-in, as there's going to be lots of versions of the spreadsheet, and I don't want to have to recall the spreadsheets if some code changes are needed.
How can I get code in the add-in to tie in to the Worksheet_Activate event?
I know I've done it before, but can't remember how I did it!
I want to have some code in the add-in that is called when one of the sheets is activated. (separate modules for each of the sheets)
Of course, I could have some code in SS.xls, but I want it all in the add-in, as there's going to be lots of versions of the spreadsheet, and I don't want to have to recall the spreadsheets if some code changes are needed.
How can I get code in the add-in to tie in to the Worksheet_Activate event?
I know I've done it before, but can't remember how I did it!