Yes, there were macros BUT they were present all the previous times. Why
would the redo-undo function stop now? What other event could cause this?
The macros have been part of this particular worksheet for over a year with
no problem. Am I missing something? Thank you for your response.

"Dave Peterson" wrote:

Macros don't have to be in the same workbook as the data.

You may want to test to see if it really is a macro.

close excel
windows start button|Run
excel /safe
hit ok

This starts excel in safe mode. No macros will be running.

Now File|Open your workbook and make some changes.

Do the edit|undo buttons get enabled?

If they do, you could look to see (just once more) if you have any macros in
that workbook. If you don't, maybe it's an addin you installed.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Oldtimer wrote:

current sheet with problem has no macro. Been using sheets data format for
years with the redo-undo feature always availbale - until just recently. I
can insert the icons but they are "faded out" and unusable. ???

"Dave Peterson" wrote:

A common side effect of most macros is that the Undo/Redo stack is lost.

This includes macro that you run by clicking on a button and event macros that
fire in the background.

Did you recently create/install a macro?

Undo/Redo also goes away after you hit the save button.



Oldtimer wrote:

recently lost "redo-undo' feature. How do I reinstall this function? Thank
you.

--

Dave Peterson


--

Dave Peterson