I have an Excel workbook containing some ComboBox controls placed directly on the sheets. These are standard combo boxes from the Forms toolbar.

When the user uses "Save As" to save the workbook with a different name, this triggers the Change event on all the combo boxes, including ones on sheets that aren't active. This seems unreasonable as the selection hasn't actually changed. This causes various undesirable behaviour because of the code in the event handlers. The event isn't triggered on a simple "Save".

[Google suggests](http://www.google.co.uk/search?sourceid=navclient&ie=UTF-8&rlz=1T4GGLL_en-GBGB320GB324&q=%22save+as%22+triggers+events+excel) this is a known problem in Excel. There are [rumours](http://groups.google.co.uk/group/microsoft.public.excel.programming/browse_thread/thread/de70c3d510f9d4bc/ac39ab318e5ca14d?hl=en&lnk=gst&q=%22save+as%22+triggers+events+#ac39ab318e5ca14d) that it's caused by using a named range as the ListFillRange for the combo box, which I have done, although it's not a volatile name. I'm looking for a way to prevent this happening with minimal changes to the code and the spreadsheet. Does anyone have a proven solution?