"Save As" Causing a combobox change event to trigger?
 

Hi all,

I'm having problems with a financial model using a drop-down type
combo box. When I select "save as" to the save the file under a new
name its triggering the event change code for my combo box, which in
turns changes formats on some pages.

Does anyone no of a way to stop the event from triggering when I use
"save as"??

Thanks in advance....AJ

"Save As" Causing a combobox change event to trigger?
 

Application.EnableEvents = False
ActiveWorkbook.SaveAs
Application.EnableEvents = True


"AJ Master" wrote:

Hi all,

I'm having problems with a financial model using a drop-down type
combo box. When I select "save as" to the save the file under a new
name its triggering the event change code for my combo box, which in
turns changes formats on some pages.

Does anyone no of a way to stop the event from triggering when I use
"save as"??

Thanks in advance....AJ