undo

Hello, I have already created a macro to do some operations on a spreadsheet, and I also want to be able bring this spreadsheet back to its original format and restore all changes (UNDO). I do know, that in Excel you can't undo a Macro directly so probably I was thinking if there's an...

Hello, I'm relatively new to VBA. Sometimes I'll run a macro that has a mistake i it and it messes up my whole worksheet. Undo doesn't work in these cases, and if the sheets has been saved during the macro, I can't just close and reopen the workbook to the last saved place. Is there some sort...

Hi, Appreciate the title is quite broad so I'll be specific. I'm using the code from the website below, it basically creates a "User Defined Function" (UDF) in Excel which can be used to change chart axis values. It's quite helpful but now the Undo feature stops working. Is there some sort...

Hi I saved a file as read only (save-->tools-->others--> checked [] read only). Now even for me, it open as read only. If I want to save it, it will create a copy of it and save the copy but original one is still read only. How can I undo Read only or that is not possible? Thank you. Thanks

Hi, I am looking for a vba code for my module which will undo my works. thank you

Hello How to prevent Redo and undo from being disabled in worksheet.change vba?

Cross-post! I have macros ··· to fill; font color; insert note. For them, not working Undo/Redo (which are located on the QAT) or CTRL+Z – CTRL+Y. I Found these links wellsr.com and jkp-ads.com there is info, though it is not clear how to combine it all with all my macros!? :confused: 1...

Hi, I've developed a macro that pastes values for a highlighted selection even if that selection is filtered. Two questions - have I done this correctly? Is there a way to build in an undo function? Obviously since it's a macro you can't just hit the undo button. Sub PasteRight()...

I've been working on this spreadsheet for a while now, and I'm not sure what I put in the code to make it stop working because it was working fine until today. I went to the Registry Editor and made an UndoHistory entry and it will undo an entry if I have a cell selected and want to undo the...

Hi I typed =now() and I got 4/25/19 8:31, then I changed cell format to general and I got 43580.3552 My question, how can I get 4/25/19 8:31 back (day and time) from that number 43580.3552 ? (suppose undo is not working)

Hi In my workbook, I have disabled Formula Bar and Headings (from View). This file is password protected. Password. I have 'auto-hide' ribbon too. However, by doing this, the 'undo' and 'redo' buttons that sits on the top in the "Quick Access Toolbar" disappears. Yes, we can always take our...

Hi I can make an excel file as a read only, save as-->tool--> check read only (no password just read only). Now I open the file and it is read only. How can I undo that? I mean I remove read only thing. Thank you very much

Hi, I posted a question about this earlier, but have discovered a little bit more on my own and have run into a different problem. With the following code, the Undo function is effectively removed. Do I have any options for replicating this code but not making it a worksheet change dependent...

Good day. I am running Excel out of Office 365 on Windows 10. All of a sudden the Undo and Redo functions in the Menu bar are grayed out and when I position the mouse over them, it says the function is not available, use Control-Z which does nothing. I have looked through the options, but I...

I have the following XML Code to present the user with UNDO & REDO QAT Options in my workbook The commands and buttons do work - However I am only able to UNDO (or REDO) 1 level back - I was hoping to get several UNDOs if needed Not sure how many are provided in standard Excel Ribbon but I...

How can I use ExecuteExcel4Macro to set a column width? The reason I want to do this instead of through VBA is that ExecuteExcel4Macro seems to keep the Undo stack intack whereas VBA will clear the Undo stack. I tried this but it didnt work: Application.ExecuteExcel4Macro...

Hello, Hope you are all well. I love my Macro's, they're great. From time to time though, I run one of my macros and something happens that I didn't anticipate. Normally, when such a thing happens I can hit the key command Control + Z and then boom! I can undo the last action that I've done...

Hi Can I wrote a code to undo whatever I have done. at any level, Sheet/Range/cells. I just want to create a button and assign macro to that button to undo whatever user did? Thank you so much.

I have a pretty simple bit of code that I'm having trouble with. All it is supposed to do is Undo the last action, then format a target cell. If it is run twice in succession, I get the error - Run-time error '1004' undo of object _application failed. For instance, if I type the word "test"...

I have a macro that enables a simple Undo of a macro update of a sheet. After the macro is run the user is asked if they want to Undo the update. With 2016 I'm experiencing a problem shown in the image at https://www.screencast.com/t/AVZvslfnhFM which is also described below... If they say...