View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default undo what a macro's done

Take a look he

http://j-walk.com/ss/excel/tips/tip23.htm

In article ,
"mika." wrote:

I have some useful VBA code that inserts rows (and keeps
the formatting, calculations, etc. as well), called from a
button. I also have a button that allows the user to
delete some rows and not others. Unfortunately, if the
user messes up there is no way to undo the insert or
worse, the delete. Can anyone suggest a way where I can
have use of the excel's "undo" to get around this, or can
you suggest another idea perhaps?

Thanks.