View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] thulasidhar@gmail.com is offline
external usenet poster
 
Posts: 3
Default Prevent automatic combobox event trigger

Hi,
i am facing problems with comboboxes in excel workbooks.
my workbook contains few sheets each of which contain one or two
comboboxes.
The event procedures for these comboboxes, fill certain cells based on
some calculation.
The listfillrange of these comboboxes are populated using named ranges.
The problem is that, whenever i add or delete certain rows in the named
range or do file-saveas
the event procedures of these combos are getting called.
Can someone explain what iam doing wrong here?

regards
thulasidhar