Prevent automatic combobox event trigger

T

thulasidhar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top