....

1) create your macro (probably using the macro recorder). Run it a few times
though Tools > Macro so that you are sure it does what you want.

2) Edit > Toolbars > Forms

3) On the forms toolbar, select the command button. Drag and drop it into
your sheet. Excel will ask you if you want to link it to a macro, so choose
the one you created above.
--
Allllen


"dcik" wrote:

> ...

Create your macro, drag a button off of the forms toolbar, and assign the
button to the macro when prompted.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dcik" <(E-Mail Removed)> wrote in message
news:62BB0E8B-083E-4673-A841-(E-Mail Removed)...
> ...