I have a problem and it is based on not udnerstanding why a Combobox_change
event fires when a workbooks is saved.

I have activex combobox on a sheet, when this box changes other actions fire
based on the selection from the control. One of these is to clear ranges in
the workbook.

All this works fine.

However when I close the workbook, the combobox_change event fires which
clear the ranges.

I am confused as to why the combobox_change event fires!!!!!

I want to save the workbook without the combobox_change event firing.

Any ideas anyone?