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 Glen,

You would need to write your own undo procedure. See:

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


---
Regards,
Norman
wrote in message
...
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

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
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