Handling Multiple Events in Excel 1

[niceguymattx]

Hi all,

Is there any way to have one procedure or class that can handle multiple events?

Specifically I would like to have a sepcific function fire on the double click event of any worksheet. Even if a new worksheet is added.

The only way I can think of doing it is by writing code at runtime - but I'd rather avoid that method, and find something that doesnt raise security issues.

Any ideas?

Thanks

Matt

 

[TonyJollans]

Take a look at the Workbook - or Application - SheetBeforeDoubleClick Event. Does that not do what you want?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[niceguymattx]

That does exactly what I want!!!!

Cant believe I missed that!!

Thanks Tony