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

A

AJ Master

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
 
J

JLGWhiz

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

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

Similar Threads

Difficulty with compatibility mode and Track Changes 2
combobox change event triggered without change 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Combo box change event triggered from another file 0
Copy Sheet causes Combo Box change event to fire on original sheet 0
Copy worksheet without triggering events 2
Why is this Worksheet Change Event triggered? 7
closing another file by code causes failure to run workbook activate event 2

Top