Therefore, it will not let me undo some of the simplist tasks. Thread Status: Not open for further replies. it's like every action is final. Therefore, ... check over here
Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not OK, just removed the Macro and BLAM: Undo works again. Mostly useless, but provide amusement when pushed down the stairs. More questions If you could use Ctrl-Z in your life what would you 'undo'? http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/undo-redo-buttons-constantly-grayed-out-in-excel/84d85228-60eb-4715-ac8d-e3aa5066ca57
Delete the existing macro you had and then put the new one in the "Sheet1 (On)" object. In the Categories list, select Macros. In fact, it made it worse.
Screen Shot of Classic Menu for Excel Awards More Awards & Reviews Products Brings Back Old Menus to Excel 2007 Brings Back Old Menus to Excel Brings sailracer, Apr 24, 2010 #12 Sponsor This thread has been Locked and is not open to further replies. I do not know what triggers the undo to stop working. Can't Undo In Excel 2013 Your cache administrator is webmaster.
Previously I had a 5-10 second window where I could undo. Microsoft Word Undo Button Disabled slurpee55, Mar 17, 2010 #4 sailracer Thread Starter Joined: Mar 12, 2010 Messages: 6 Thanx for the reply, slurpee55. You can then create a separate macro that reads this information and effectively undoes the effects of the first macro. But I'll take a look at that, too.
When you go into format or settings go into the advanced area and make sure nothing is selected that would say "never allow changes to be undone" or "always keep changes" How To Modify The Number Of Undo Levels In Excel 2010 You can realize the Undo function with a classic style in Excel 2007/2010/2013. Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
View the most recent issue. click site How to I restore my Excel undo function? Undo Not Working In Excel 2013 Anyway, I was able to set the entry to 16 (the normal default value), and I'm back to normal. Undo Not Working In Word 2013 How do I stop it from doing this or do I need to keep macros disabled while I work on files?
Pedro Pedro15, Mar 12, 2010 #2 sailracer Thread Starter Joined: Mar 12, 2010 Messages: 6 Thanx for the reply. http://techese.net/in-excel/undo-function-not-working-in-excel-2010.html Wow, that seems silly. Register To Reply 07-12-2013,10:44 AM #5 Sandcastle View Profile View Forum Posts Visit Homepage Forum Contributor Join Date 05-23-2013 Location Mississauga, ON MS-Off Ver Excel 2010 Posts 131 Re: Why do Thanx to all who helped on this. Undo Not Working In Word 2010
I'm not sure how you would go about getting it to change with selection without using a macro. Wyrmlord tried next with some good suggestions. Thank you for your help. this content Highlight each macro in the Macros list until you find the culprit (the keyboard shortcut will appear in the Current Keys control.
Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Excel 2013 Undo Greyed Out CTRL+Z = undo. I have mine at 30, and it doesn't slow down my machine at all.
You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Preserving the Undo List. This is also a neat little tweak for those that UNDO a lot. I would expect the operations of the Macro to be separate from the history of the document's actions. Undo Button Greyed Out In Word 2010 In the Commands list, choose EditUndo.
Posts 4,418 Re: Why do some Excel documents NOT allow me to Undo/Redo when using THIS Macro? Answer Questions Can't install iTunes or chrome on new pc? Expand» Details Details Existing questions More Tell us some more Upload in Progress Upload failed. have a peek at these guys Can anyone help?
I had been mucking about with some... dumples View Public Profile Find all posts by dumples #8 08-20-2010, 04:07 PM E Eddie Smith SOA AAA Join Date: May 2003 College: UGA Posts: 8,612 Quote: Originally If you feel that you might want to undo the effects of a macro, the first thing you can do is to save your workbook before running the macro. Something that begins with Private Sub Worksheet_SelectionChange(ByVal Target As Range) Was this answer helpful? 00 · 04/16/2012 07:12 JoeStewart Well, after asking around at work I finally found the answer to my problem
Share it with others Like this thread? When ever you run code in a workbook the undo stack is cleared. When your primary macro is through running, there will only be a single option available on the Undo list: Primary Macro.