View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bhavtosh Bhavtosh is offline
external usenet poster
 
Posts: 9
Default 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