can you not protect the cells you don't want changed??

You could hilight the cells that are allowed to be changed and then
format.cells ,protection, uncheck locked

then protect the sheet, tools,protect sheet

the cells that are protected now cannot be changed


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=540913