That's an unfortunate side effect of using event code. If you want to be able to 'undo', you would
need to store the values ion a record sheet (using the change event) and have another macro that
would allow you to transfer the stored value back to the data sheet. Not too hard, just need
different code and another sheet.

If you are interested in doing that, post back.

HTH,
Bernie
MS Excel MVP


"GGG" wrote in message
...

One quirk - when the scrip is enabled it disables the "undo"
functionality. Any ideas? If I disable the macro, the functionality
comes back

At least I can keep track of _when_ I made an error! Just can't undo
it. (Excel 2002 SP3)


--
GGG
------------------------------------------------------------------------
GGG's Profile: http://www.excelforum.com/member.php...o&userid=29220
View this thread: http://www.excelforum.com/showthread...hreadid=489447