undo

I have a spreadsheet that runs a VBA code for conditional formatting. The code works fine, but now undo/redo/repeat, etc. are disabled for the entire workbook (even the cells that are not in the range for the conditional formatting). All my other Excel files are fine so this is not a...

Hello, I have a 'yes/no' message box which the user will interact with. If the user clicks 'no' I want vba code to undo the users last change (to the worksheet's data); any ideas? If it makes any difference, the message box is triggered by the worksheet_change event. -B

Hi, In one of my workbooks the undo function has stopped working. Additionally I can not copy and then insert rows/columns. The workbook has no event macros, or any other code to speak of. These functions work correctly in other workbooks. Does any know of a possible cause/solution? I am...

Hello, I am using the following macro to start a double click event to start a combobox and also enter "1" or "0" in different adresses from the combobox addresses. I just figured out that in the below macro, I guess the error handler or the window reset it also empties the list in Undo...

Hi I have a large spreadsheet that should be used for a construction. To use it for the next construction I have made a macro called "NySag" It selects the area with data for this construction and clears it, then it opens the Save As dialog in order to save the emptied spreadsheet in a new...

Hi! Seasons Greetings! In MS-excel 2003, I have written macros for different actions on a work sheet. For every action I am storing the previous and current values of the affected range in an array for a later undo and/or redo of the macro actions. At the end of every macro that are invoked by...

It just happened again. I unintentionally deleted a worksheet and trying to recover it was impossible. Undo does not work for this purpose. I tried copying all the extra work into a new document and then I forced a shutdown of my computer to make excel crash and then after I restarted I was...

I am using Excel 2007 and occassionally my undo button will clear its memory and will be greyed out. Therefore, it will not let me undo some of the simplist tasks. I do not know what triggers the undo to stop working. I would like it so it never does this. Let me know if I can explain...

I was wondering if anyone can help me with this. (ps I'm new at vb but enjoying it immensly) Sub AcceptPriceChangesClient1() Range("c13:v13").Select Run ("PriceChangesStep1") ' to copy range c13:v13 Sheets("1").Select Run ("PriceChangesStep2") ' to paste...

I have come across what I think is an excel bug, or maybe I have done something wrong. I'm using excel 2007<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have created several dynamically named range that is used to fill active X combo boxes...

Hello, I am very new to this and to VBA writing. Up to this point I have been recording macros and then searching for code to change what I recorded to do what I want it to do. I tell you this to let you know, I know very little but am enjoying the learning process. I got an insert image...

I have numerous rows/cells (basically a monthly balance sheet) that when it doesn't equal zero means my workings are wrong. Ideally I would like a message box that appears no matter what worksheet i'm in in the workbook that appears informing me that my last actions caused the cells to not equal...

All CAPS Problem w/ Undo I searched the forum diligently and found this code (Thanks onlyadrafter and al b cnu) for making all the cells in a sheet ALL CAPS: <link rel="File-List" href="file:///C:%5CUsers%5CSam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link...

I created a macro in my personal.xlsb in Excel 2007 to paste values and assigned it to the keystroke ctrl-q. When I use this macro, it clears out my options to undo any actions, which is something I really need sometimes. Is there a different way I could make a macro to paste values with a...

Greetings, I've searched the board and this question has been raised before however, unless i overlooked it, no solution has been provided for the two following main problems caused by having a running clock in a worksheet cell : 1-Clock stops updating while excel is in EDIT MODE 2-Excel...