How to centralize an event handler for all the workbooks that are open ?

In other words I want to handle cell click event from workbook1.sheet1 in to
an addin (say HandleEvent.xla).

In the similar fashion I want to create a tool bar from this addin, only if
a specific workbook is opened.

( I remember using Public withevents oExcel as Excel.application to get a
handle to any workbook being opened from a centralize addin. But can not
recall any furthur)

Any ideas???

Thanks in advance

Nayan

Hi,

Have a read of Chip Pearson's page on application events.
http://www.cpearson.com/excel/AppEvent.aspx

Cheer
Andy

Nayan wrote:
> How to centralize an event handler for all the workbooks that are open ?
>
> In other words I want to handle cell click event from workbook1.sheet1 in to
> an addin (say HandleEvent.xla).
>
> In the similar fashion I want to create a tool bar from this addin, only if
> a specific workbook is opened.
>
> ( I remember using Public withevents oExcel as Excel.application to get a
> handle to any workbook being opened from a centralize addin. But can not
> recall any furthur)
>
> Any ideas???
>
> Thanks in advance
>
> Nayan
>
>
>