Increase Number Of 'Undos' In Access+Excel..

ACCESS

Open your registry and find or create the key below.
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\A ccess\Settings
Create a new DWORD value, or modify the existing value, called "Number of Undos" and set it according to the value data below.

(do that by going right click and new and then 'dword')

double click on it and set the value from 1 to 20

Exit your registry; you may need to restart or log out of Windows for the change to take effect.


EXCEL


Open your registry and find the key below where [version] is "9.0" for Excel and "10.0" for Excel .
HKEY_CURRENT_USER\Software\Microsoft\Office\[Version]\Excel\Options
Create a new DWORD value, or modify the existing value, named "UndoHistory" and set it to the number of undo levels between 0 and 100.