Undo levels
Posted by Tal on April 03, 2000 9:36 AM
The undo and redo buttons on my screeen remain grey and are therefore unusable.
Through help I found the default number of undo levels is 16 but I cannot find where
to set them as I assume mine are either disabled or set to zero.
Posted by Ivan Moala on April 03, 2000 11:22 PM
Tal
To do this you will need to change the registry setting;
From MS;
On the Start menu, click Run. Type regedit and click OK.
In the Registry Editor, expand the following key:
HKey_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel
On the Edit menu, point to New and click DWORD Value. With "New Value #1" selected, type UndoHistory, and then press ENTER.
On the Edit menu, click Modify. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 for Value. Click OK and quit the Registry Editor.
Note the more undos you enter the more memory that is required. Ms suggest max of 100.
HTH
Ivan
