|
cannot enable redo-undo function
recently lost "redo-undo' feature. How do I reinstall this function? Thank
you. |
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 |
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 |
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 |
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 |
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 |
cannot enable redo-undo function
I did the "SAFE MODE" thing with no affect. I will try turning off additions
tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 |
cannot enable redo-undo function
If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins
from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson |
cannot enable redo-undo function
'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail.
This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson |
cannot enable redo-undo function
Perhaps check if anyone messed around with your Reg settings.
Setting it to 0 disables Undo. How to modify the number of undo levels in Excel http://support.microsoft.com/kb/211922/en-us -- HTH :) Dana DeLouis Windows XP & Excel 2007 "Oldtimer" wrote in message ... 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson |
cannot enable redo-undo function
I'd check what Dana posted.
I'd guess that any reinstall wouldn't help. Lots of times, the reinstall doesn't touch the problem area. Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
And you are positive that you did something that could be undone, right?
And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
EUREKA! Excellent. Perhaps the recently installed 'Registry Booster'
program messed with the registry or maybe a Bill Gates "update". In any event the value in the registry was 0 [zero]. Reset to default 16. All is well. Thank you both very much. Ed Barker "Dana DeLouis" wrote: Perhaps check if anyone messed around with your Reg settings. Setting it to 0 disables Undo. How to modify the number of undo levels in Excel http://support.microsoft.com/kb/211922/en-us -- HTH :) Dana DeLouis Windows XP & Excel 2007 "Oldtimer" wrote in message ... 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson |
cannot enable redo-undo function
Thanks for your input. Dana's suggestion was a winner as the registry value
was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Yep. I saw your reply to Dana.
Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Dave, I read this post and it was helpful. Backing up, I cannot do
F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
How about just assigning a shortcut key to the macro and hit that shortcut key
combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Tools|Macro|macros
select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts,
but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Don't use F4. Use the shortcut keys.
MrMojoReising wrote: Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts, but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Apologies again, neither F4 nor Ctrl+Y work
"Dave Peterson" wrote: Don't use F4. Use the shortcut keys. MrMojoReising wrote: Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts, but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Right.
Use the shortcut keys for the macto--not the f4/ctrl-y keys. MrMojoReising wrote: Apologies again, neither F4 nor Ctrl+Y work "Dave Peterson" wrote: Don't use F4. Use the shortcut keys. MrMojoReising wrote: Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts, but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
Backing up, you're suggesting I use the shortcut keys for the macros I
created? I was doing this. Or did you mean create another macro (with a shortcut) for the REDO function and bypass the F4/Ctrl+Y stuff? "Dave Peterson" wrote: Right. Use the shortcut keys for the macto--not the f4/ctrl-y keys. MrMojoReising wrote: Apologies again, neither F4 nor Ctrl+Y work "Dave Peterson" wrote: Don't use F4. Use the shortcut keys. MrMojoReising wrote: Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts, but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
What are you using the F4 shortcut for? To redo what, if it is not for
repeating the macros it should work, if it is for repeating the macros it won't work but instead you could use the macro keyboard shortcuts? You might also want to post the code for the macros. -- Regards, Peo Sjoblom "MrMojoReising" wrote in message ... Backing up, you're suggesting I use the shortcut keys for the macros I created? I was doing this. Or did you mean create another macro (with a shortcut) for the REDO function and bypass the F4/Ctrl+Y stuff? "Dave Peterson" wrote: Right. Use the shortcut keys for the macto--not the f4/ctrl-y keys. MrMojoReising wrote: Apologies again, neither F4 nor Ctrl+Y work "Dave Peterson" wrote: Don't use F4. Use the shortcut keys. MrMojoReising wrote: Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts, but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
cannot enable redo-undo function
I am suggesting that you use the shortcut keys for the macros you wrote.
MrMojoReising wrote: Backing up, you're suggesting I use the shortcut keys for the macros I created? I was doing this. Or did you mean create another macro (with a shortcut) for the REDO function and bypass the F4/Ctrl+Y stuff? "Dave Peterson" wrote: Right. Use the shortcut keys for the macto--not the f4/ctrl-y keys. MrMojoReising wrote: Apologies again, neither F4 nor Ctrl+Y work "Dave Peterson" wrote: Don't use F4. Use the shortcut keys. MrMojoReising wrote: Sorry, I think I was unclear. I did HAVE two simple macros with shortcuts, but the F4/Redo function wouldn't work with macros turned on, so basically I have to choose b/w the two. I can create the macros, but then the F4 function doesn't function. Thoughts? "Dave Peterson" wrote: Tools|Macro|macros select your macro Click Options and assign your shortcut key there Remember to save your personal.xls file with this change. Dave Peterson wrote: How about just assigning a shortcut key to the macro and hit that shortcut key combo. MrMojoReising wrote: Dave, I read this post and it was helpful. Backing up, I cannot do F4=Redo/Repeat now that I made 2 simple macros in the PERSONAL.XLS file. When running in safe mode, this is corrected as macros are off. Is there a way to have both the F4 functionality AND my very simple macros? I know this worked before (together) but no longer. "Dave Peterson" wrote: Yep. I saw your reply to Dana. Oldtimer wrote: Thanks for your input. Dana's suggestion was a winner as the registry value was 0 [zero]. Perhaps recently installed REGISTRY BOOSTER program was the culprit. Everything now back to normal. Thank you both. "Dave Peterson" wrote: And you are positive that you did something that could be undone, right? And that didn't work in Safe mode, either?? Even with a brand new workbook??? (Yep, I'm grasping at straws???!!?) Oldtimer wrote: 'Edit/Undo' is faded out - "Can't Undo Ctrl Z". Reset toolbars to no avail. This is really weird. I'm ready to save all files and remove Excel and re-install. Any thoughts on this drastic measure? Will the saved files function properly when (if) the redo-undo feature is restored? "Dave Peterson" wrote: If safe mode didn't work, then I bet it's not an addin. Safe mode stops addins from running. Does Edit|Undo still work? Maybe it's just that someone was screwing with the icons and disabled them? I'd try this first, er, next. Tools|Customize|Toolbars Tab| select the Standard toolbar click reset Note that any changes you've made to that toolbar will have to be redone. If edit|undo is always disabled, you could try resetting the worksheet menubar, too. Oldtimer wrote: I did the "SAFE MODE" thing with no affect. I will try turning off additions tomorrow with a hopefully clear head. Appreciate very much your input. "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com