Graham -

My TreePlan decision tree add-in for Excel, available at www.treeplan.com,
is still 99% XLM code. However, I do plan to rewrite it completely in VBA
Real Soon Now.

Regarding Undo, see John Walkenbach's page "Undoing a VBA Subroutine,"

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

Also, see a current thread in this programming newsgroup (which you can
search using Google Groups): "Why Undo commandbutton is Cleared ?"

- Mike
www.mikemiddleton.com

"Graham" wrote in message
...
Mike,
Thank you. That works a treat. So simple! I feel a bit of a fool for
not
thinking of it myself.
Incidentally, when you wrote "What I do..." does that imply that you still
use Excel 4 macros yourself? If so, I wonder if you know any way of
preventing them from disabling the multiple undo facility? When an Excel
4
macro is running which responds to entries by the user by writing data to
a
spreadsheet, Excel only seems to permit a single action to be undone.
Pressing Ctrl+Z undoes the last thing the macro did, not the last thing
the
user did, and pressing Ctrl+Z a second time has no effect. So in
practice,
the undo facility is disabled completely.
I had hoped that saving the macro as an add-in would solve this problem,
but
I just tried out a little test macro saved as an add-in using your method,
and I find it doesn't. I'd be grateful for any suggestions.
Many thanks to you and to Tom Ogilvy for your time and expertise.
Best wishes,
Graham