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.

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.