Auto Populate sheet name of active workbook in Combobox in Command

[Bhavtosh]

hi all,
i have an addin which has a Combobox in a commandbar and in the Auto_Open
event of commandbar impopulating sheet names of active workbook but im not
able to populate the same when i open another excel file.
may be because the addin is already open in Excel... pls help how to achieve
this for any excel file.. am im missing writing code in a particular event???
--
thanx..
Bhavtosh

[Tom Ogilvy]

In you addin you need to instantiate application level events. Then you
can trap the opening of a workbook

See Chip Pearson's site for an introduction:

http://www.cpearson.com/excel/AppEvent.htm

--
Regards,
Tom Ogilvy

"Bhavtosh" <[email protected]> wrote in message
news:[email protected]...
> hi all,
> i have an addin which has a Combobox in a commandbar and in the Auto_Open
> event of commandbar impopulating sheet names of active workbook but im not
> able to populate the same when i open another excel file.
> may be because the addin is already open in Excel... pls help how to
achieve
> this for any excel file.. am im missing writing code in a particular
event???
> --
> thanx..
> Bhavtosh

[Bhavtosh]

thanx for a gr8 link; it did help in knowing more abt events. one more favor
if u can do. right now user can type in the combo box how can i prevent it or
how can i make it just a normal drop down?

thanx
bhavtosh

"Tom Ogilvy" wrote:

> In you addin you need to instantiate application level events. Then you
> can trap the opening of a workbook
>
> See Chip Pearson's site for an introduction:
>
> http://www.cpearson.com/excel/AppEvent.htm
>
> --
> Regards,
> Tom Ogilvy
>
> "Bhavtosh" <[email protected]> wrote in message
> news:[email protected]...
> > hi all,
> > i have an addin which has a Combobox in a commandbar and in the Auto_Open
> > event of commandbar impopulating sheet names of active workbook but im not
> > able to populate the same when i open another excel file.
> > may be because the addin is already open in Excel... pls help how to
> achieve
> > this for any excel file.. am im missing writing code in a particular
> event???
> > --
> > thanx..
> > Bhavtosh
>
>
>

[Bhavtosh]

thanx for a gr8 link; it did help in knowing more abt events. one more favor
if u can do. right now user can type in the combo box how can i prevent it or
how can i make it just a normal drop down?

thanx
bhavtosh

"Tom Ogilvy" wrote:

> In you addin you need to instantiate application level events. Then you
> can trap the opening of a workbook
>
> See Chip Pearson's site for an introduction:
>
> http://www.cpearson.com/excel/AppEvent.htm
>
> --
> Regards,
> Tom Ogilvy
>
> "Bhavtosh" <[email protected]> wrote in message
> news:[email protected]...
> > hi all,
> > i have an addin which has a Combobox in a commandbar and in the Auto_Open
> > event of commandbar impopulating sheet names of active workbook but im not
> > able to populate the same when i open another excel file.
> > may be because the addin is already open in Excel... pls help how to
> achieve
> > this for any excel file.. am im missing writing code in a particular
> event???
> > --
> > thanx..
> > Bhavtosh
>
>
>