Data Analysis disables my toolbar

[Sai]

Hi,

I wrote a COM Add-in, which will create a tool-bar to do some
operations on the excel document. The toolbar is having 4 buttons and
initially the 1,3 and 4 buttons are enabled by default and button 2 is
disabled. Based on the document state the buttons get enabled and
disabled.

As soon as somebody access the Data Analysis, the toolbar buttons gets
into original state i.e., 1,3 and 4 are enabled and 2 disabled, and
once you close the data analysis window, the toolbar buttons doesnt get
back to the current state.

For example before you access the data analysis, the following buttons
are enabled (1, 2, and 4) and 3 is disabled, once data analysis is
accessed, it comes to the original state (1, 3 and 4 are enabled and 2
disabled) and after you close the data analysis window the toolbar
buttons does back to the current state (1, 2 and 4 enabled and 3
disabled), instead it sticks to the original state (1, 3 and 4 enabled
and 2 disabled).

How can I trap the event for data analysis access or data analysis
window close?

Appreciate your help.

Thanks
SAI

 

[Sai]

Nevermind, I found the resolution.

Thanks
SAI