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