Excel

Undo - change undo history

Ivan F Moala

Can Do

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

Ever needed to change Excel's Undo History?

Here is one way to do this using scripting.

By default Microsoft Excel keeps track of 16 undo levels, which provide an undo history for most actions you perform in Microsoft Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. Note, I said Adding as by default this entry is not part of the registry for Excel. Microsoft recommends that you do not increase the number of undo levels beyond 100.

NB: The more you increase the number of undo levels the more random access memory (RAM) Microsoft Excel requires to store the undo history as this affects the performance of Excel.

This is due to the fact that the higher the undo history value the more memory Microsoft Excel allocates for the history. A common question asked about running VBA routines is;

"Can we Undo the actions performed by a Macro" The simple answer is NO. When you run a Visual Basic for Applications macro, Excel allocates NO memory for undoing actions. This feature is disabled for optimization and performance when you run a macro.

WARNING:

If you use the Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Use Registry Editor at your own risk!

Please check your registry entry before running this routine.

If you cannot see the code Window below with code in it then click here.

Page created 29th Nov 2003