Undo row insert from macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that inserts rows and enters some default
data. When I do that, the undo menu in excel is grayed
out. I want to give the user the option to undo the
entry. When from a user defined menu. I tried
Application.undo but that got an error message.

Is what I want possible?

TIA
Glen
 
Hi
not really possible with using a macro. The only way would be to create
you own 'Undo' functionality for your macro (e.g. storing the
column/sheet on a separate hidden sheet -> probably not worth the
effort).

So in total: Using macros disables the 'Undo' functionality
 
Back
Top