....

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" wrote in message
...
...