redo

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

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

I have a spreadsheet which has many +COUNTIFS, +SUMIFs in a series. Example =COUNTIFS(A1:A100,"*Name*",B1:100,"*Title*")+COUNTIFS(A1:A100,"*Other*",B1:100,"*Other*")+COUNTIFS(A1:A100,"*Var1*",B1:100,"*Var2*")+ If I redo with something like this below, would this improve excel's ability to...

Hi, I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value...

Hi There In one of my worksheets, the undo function has stopped working, it has been suggested that the problem I am having is due to the VB applied to this worksheet: Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 'Update 20140318 Static xRow Static xColumn If xColumn <> ""...

Well Hello, it has been a while since I posted. I have searched the forum, but can't find an answer. I don't use Excel as much as I used to (career change) just personal stuff now, and I am perfectly happy with Excel 2003 for what I do. I now have a new laptop running windows 8.1, I was...

Hi, I'm almost there to solve the loss of undo/redo-stack and clipboard by VBA made changes. I can already find out if the last keypress was undo or redo: If GetKeyState(vbKeyY) And -128 And GetKeyState(vbKeyControl) And -128 Then ' "Ctrl-Y" has been pressed If GetKeyState(vbKeyZ) And...