Auto Populate sheet name of active workbook in Combobox in Command

[Guest]

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???

 

[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

 

[Guest]

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

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