View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default In Excel, UNDO/REDO is grayed out. How can I turn it back on?

Are you sure you changed the correct key/value?

SD Matthews wrote:

I too have this problem, but editing my Registry failed to solve it on my
machine.

"Dave Peterson" wrote:

There are lots of things that can reset the undo/redo stacks.

You could have run a macro (or an event macro could have fired).

You could have saved the workbook.

There's a setting in the windows registry that tells excel how many undo levels
to keep track of--maybe it was set to 0.

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944

DeerMusic wrote:

My Excel 2003 undo and redo buttons (the icons and in the menu) are grayed
out and unavailable. What could cause that? How can I make the them active
again? This happens in both existing and new spreadsheets. Thanks.


--

Dave Peterson


--

Dave Peterson