ComboBox/Dropdown change events triggered when Saving As

Hi,

I am having some trouble with the triggering of events by a change in ComboBox or DropDowns. In particular, when I "Save As" the file, some (or maybe all, I am not sure) of the macros attached to a change in ComboBoxes and Dropdowns are triggered.

Is there anyway to avoid this? Any idea?

Thanks a lot in advance

Have a look in the ThisWorkbook module. You will find a BeforeSave event there where you can set a global, Boolean variable that you can use to suppress the event handlers in your ActiveX objects.


Sent from my iPhone using Tapatalk

That worked!! Thanks a lot!

Good job!


Sent from my iPhone using Tapatalk