+ Reply to Thread
Results 1 to 2 of 2

simple undo/redo vba

  1. #1
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    simple undo/redo vba

    Hi. I was wondering if it is possible to do a simple undo/redo routine with VBA, what I need is an undo redo feature that only works BEFORE a macro is executed. The only thing I can find is complex information on how to undo a macro, that isn't what I need. Basically I have a user form that will unhide or hide rows, sometimes I will accidently hide a row that I did not mean to hide and would like a button to undo the last command to see what row was accidently hidden then click redo to well redo to rehide the unhidden rows
    Last edited by randell.graybill; 10-28-2009 at 10:10 PM.

  2. #2
    Forum Contributor
    Join Date
    04-03-2009
    Location
    USA, California
    MS-Off Ver
    Excel 2007
    Posts
    385

    Re: simple undo/redo vba

    Application.Undo

    is the answer it is both undo and redo.

    half way stumbled upon this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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