longtalker

Many times I find myself wanting to Undo commands done within a certain worksheet, without undoing other commands that might have been performed in other sheets in the meantime. However, if I have a couple of commands done in one sheet, then some other commands in another sheet, the Undo command will undo them all in a row, without keeping track of the sheet where those commands were performed. This also goes for several workbooks: the Undo is still common for all of them, even though they're different files even! This is strange, because in Word for example, if you ave several documents open, each has its own Undo list, independent from other documents'.

Does anyone know a way to have separate Undo lists - one for each sheet or workbook? Thanks!