undo button

I created a sub that is able to undo a macro for me, by creating a copy of the original format then deleting the latest copy and retrieve the old copy back. When I am backing up that particular sheet I give it a different name. Then, when running the macro that I want to execute it cannot...

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...

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...

Hey everyone! I have created an excel in which I insert blood exam results. I insert every patient manually. What I want to do is to assign a key (for example F5) to undo all changes made to the sheet at once. I know I can do it using undo button, but I'd like to have a specific key for that.

Hi I have some VBA code that basically checks if there's an error message in cell M58, then display a Command Button "ClearError1" Private Sub Worksheet_Calculate() On Error Resume Next If IsError(Range("M58").Value) Then ClearError1.Visible = True 'Else ClearError1.Visible = False End Sub...

I am completely new to VBA and have learned quite a bit in the last week by working slowly on a personal project of mine. I have most of the essentials set up, but it is imperative that I provide the user the ability to undo a data submission when using a User Form. My submission code is as...