| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot enable redo-undo function
recently lost "redo-undo' feature. How do I reinstall this function? Thank
you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enable redo-undo function
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enable redo-undo function
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enable redo-undo function
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enable redo-undo function
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enable redo-undo function
It could be a _change event, _selectionchange event. Who knows?
It's not really the event that causes the problem. It's what happens inside that event. Not all macros (including events) kill the edit|undo stack. Did you install any other addin? Did you follow any of those instructions to turn off all other addins/workbooks and then add them back one at a time until you find the culprit? Oldtimer wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| undo and redo do not work | Excel Worksheet Functions | |||
| Why Undo and Redo button are disabled in my Pivot | Excel Discussion (Misc queries) | |||
| increase undo/redo action | New Users to Excel | |||
| Excel should undo/redo after saving a file--just like Word. | Excel Discussion (Misc queries) | |||
| undo/redo action | Excel Discussion (Misc queries) | |||
Hybrid Mode
