Auto Populate sheet name of active workbook in Combobox in Command
 

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

Auto Populate sheet name of active workbook in Combobox in Command
 

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" wrote in message
...
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

Auto Populate sheet name of active workbook in Combobox in Com
 

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" wrote in message
...
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