You could set an event flag to bypass its action
Public fDisableEvents As Boolean
Private Sub ComboBox1_Change()
If Not fDisableEvents Then
MsgBox ComboBox1.Value
End If
End Sub
and disable the flag before the SaveAs.
--
HTH
Bob Phillips
"jbl25" wrote in
message ...
Hello,
I have a file with a large number of combobox controls on several
sheets. On SaveAs, every combobox change sub runs, which resets many
of the combobox values. I saw in a previous thread that this is due to
the comboboxes being linked to cells, and the recalculate before save.
Even if I turn the autocalculate off before saving, some still change,
and others change when I turn the calculations back on. I need to
store the selections from the comboboxes, so I must link them to cells.
How can I avoid them changing? Thank you!!!
--
jbl25
------------------------------------------------------------------------
jbl25's Profile:
http://www.excelforum.com/member.php...fo&userid=7225
View this thread: http://www.excelforum.com/showthread...hreadid=381852