Home > In Excel > Undo Button In Excel Not Working

Undo Button In Excel Not Working

Contents

Its only this tab, others it works. You can only upload videos smaller than 600MB. On event, when user change some value in cell or delete some rows, I calculate some other cell values and if it make mistake, the old values are lost forever. Is there any code? http://techese.net/in-excel/undo-in-excel-not-working.html

yes Private Sub CBBanchattach_Click() End Sub Private Sub CheckBox1_Click() End Sub Private Sub CMPrint_Click() If CBInput.Value = True Then Sheets("INPUT").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End If If CBA1.Value = True Then Sheets("I. Less You can undo, redo, or repeat many actions in Microsoft Word, PowerPoint, and Excel. Register To Reply 07-12-2013,10:49 AM #6 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 Privacy Policy| Contact Us If you have any questions or suggestions about our products or web site, please feel free to submit them to us. 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

Undo Not Working In Excel 2013

Notes:  By default, the Repeat command is not available on the Quick Access Toolbar in Excel. I'll report back in a few moments. If you have a macro that does a lot of processing of information in your worksheet, code the macro so that it maintains, in memory, the state of anything that it Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Oct 19th, 2011,09:52 AM #6 VoG MrExcel MVP Join Date Jun 2002 Location 127.0.0.1 Posts 63,652 Re: undo button

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 please help me out.? If you can't undo an action, the Undo command is dimmed. . Undo Not Working In Word 2010 XLSX, will not contain any VBA, XLSM are Macro-Enabled and can contain VBA.

First answer posted by NataliaPeterson at 04/16/2012 07:12 Add Your Answer 10~1000 characters in length CAPTCHA: Post without login 4 Answers NataliaPeterson I suspect that what is happening is that you Originally Posted by yudlugar Edit: Actually, I don't think that the macro will "break" the undo history if you just get it force calculation. If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. http://www.techrepublic.com/blog/microsoft-office/-office-solution-what-to-do-when-ctrl-plus-z-stops-working/ You can use Office 2007/2010/2013/2016 immediately without any training.

To undo several actions at the same time, click the arrow next to Undo, select the actions in the list that you want to undo, and then click the list. Can't Undo In Excel 2013 Can a spellcaster switch between multiple foci? App: Microsoft Excel 2000, 9.0.3821 SR-1 Several months ago, the undo function (control-Z) stopped working. Redo an action To redo something you've undone, press Ctrl+Y or click (Redo) in the ribbon.

Microsoft Word Undo Button Disabled

brettj666 · 9 years ago 0 Thumbs up 0 Thumbs down Comment Add a comment Submit · just now Report Abuse well then u can just use the undo and redo https://answers.yahoo.com/question/?qid=20080420221834AAawGtI A1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End If If CBA2.Value = True Then Sheets("I. Undo Not Working In Excel 2013 Might start using it myself sometimes. Undo Not Working In Word 2013 Hello Everyone, Some of my Excel files work perfectly in terms of undo/redo, while others simply cannot use that feature.

Register To Reply 07-12-2013,07:42 AM #2 zumbalj View Profile View Forum Posts Forum Contributor Join Date 08-15-2012 Location Ohio MS-Off Ver Excel 2007 Posts 245 Re: Why do some Excel documents http://techese.net/in-excel/undo-function-not-working-in-excel-2010.html MS-Off Ver . How to Convert ICS to Excel Office Excel 2007 You can get specific information about this update in Microsoft Knowledge Base. Undo button doesn't work on Word 2007 (nor does ctrl z). How To Modify The Number Of Undo Levels In Excel 2010

Damiross was the first to respond with a helpful reminder: [Ctrl]+Z won't do anything if there's nothing to undo! Author Bio Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro this content How do I sort a list with positives coming before negatives with values sorted respectively?

I cannot imagine the purpose of that. Undo Button Greyed Out In Word 2010 ftg bending").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End If If CBFtgBending = True Then Sheets("V. Due to the size of my workbooks, this row highlighting is very useful.

When I try to save excel file it offers me xltm format.

Sorry, I didn't realise the macro was in the thisworkbook object. The time now is 02:06 AM. OK, just removed the Macro and BLAM: Undo works again. Excel 2013 Undo Greyed Out Below the Categories list, click the Customize button, to the right of the Keyboard Shortcuts option.

Is the workbook called somename.xlsm That extension means it's macro enabled. Since I don't have any macro (but i have vba code) i have saved it as xlsx. How do I create everything. have a peek at these guys This tip (2060) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Squeaky belt issues on '95 Chevy S10 How do I get the last lines of dust into the dustpan? How do I know which part of the code is doing it? Related Tips: Finding the Parent Folder Self-Aware Macros Combinations for Members in Meetings Specifying the Size of Chart Objects Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used If you can't undo an action, the Undo command changes to Can't Undo.

Is it possible to formulate the Schrödinger equation in a manner that excludes imaginary numbers? Duh! You are almost there, you need to put the code in the worksheet, not the workbook in the vba editor: V3.xlsm Register To Reply 07-15-2013,10:26 AM #13 Sandcastle View Profile View Gordon Or-8 was the first to mention the possibility that someone had accidentally usurped the shortcut by assigning those keys to a macro.

You get the "marching ants" running around it, but as you click something else, you lose the selection. Rows and columns above and left of the selected cell will be frozen. It's the shortcut for Undo; it cancels previous actions. press enter on a cell or force calculate CTRL ALT F9.

Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Share Was this information helpful? Enter your e-mail address and click "Subscribe." (Your e-mail address is not shared with anyone, ever.) Want to see what the newsletter looks like?