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