unlink the cells and use the click event to write the values to the cells.

--
Regards,
Tom Ogilvy

"jbl25" wrote in
message ...

Hello,
I tried disabling all workbook events right before saving, and also
tried setting calculations to manual before save, but the comboboxes
still changed. I have excel 2003 and have installed Hotfix SP1. Are
there any other solutions? Thanks very much.


--
jbl25
------------------------------------------------------------------------
jbl25's Profile:
http://www.excelforum.com/member.php...fo&userid=7225
View this thread: http://www.excelforum.com/showthread...hreadid=381852