+ Reply to Thread
Results 1 to 2 of 2

Workbook_SheetChange macro deletes all "undo" ("redo") states

  1. #1
    Forum Contributor
    Join Date
    02-05-2015
    Location
    czech
    MS-Off Ver
    2010
    Posts
    172

    Workbook_SheetChange macro deletes all "undo" ("redo") states

    Hello dear Excel Help Forum

    I know that all "undo states" are cleared when someone executes a macro. Thus "undo functionality" is effectively disabled when someone has Workbook_SheetChange event macro defined.
    Is there a solution to that? Like storing undo states in some object upon Workbook_SheetChange event is trigered and at the end restore the states?
    Last edited by jakopak; 02-16-2017 at 07:31 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Workbook_SheetChange macro deletes all "undo" ("redo") states

    Jwalk has an undo subroutine, I have never tried it though

    http://spreadsheetpage.com/index.php...ba_subroutine/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  3. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. Track Changes ( Makes "Undo/Redo" Function Unavailable - Any VBA to Re-Add it?)
    By karimel_romeo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2013, 12:22 PM
  6. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  7. "Undo/Redo" Feature NOT functioning
    By MWS in forum Excel General
    Replies: 3
    Last Post: 06-27-2006, 09:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1