Actually, a follow-up: Once I use the macros to populate the template
worksheet, I make a copy of it, rename that, then clear out all the data in
the original template worksheet, and start anew with different data.
However, after I've made each renamed copy, I want to remove the macro
buttons (on the copies) so a receiver of the file doesn't accidentally click
on them. How do I remove them? I see that I can move them and reduce their
size to virtually zero (also, I can edit out the text on the button, but
don't know how to completely delete the square buttons.

Thanks all!
Dean

"Dean" wrote in message
...
Thank you all.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Dean

Open the Forms Toolbar and click on the button icon.

Draw a button on your sheet and right-click and "Assign Macro".

Note: most any object can be used as a button. Drawing object, textbox
object, picture from file, Word Art can all have macros assigned.


Gord Dibben Excel MVP


On Tue, 13 Sep 2005 10:13:39 -0700, "Dean"
wrote:

I want to create buttons (in the body of my worksheet)and assign existing
macros to them and forget how. EXCEL help doesn't seem to tell me what I
do
to create a button, unless it is within a toolbar, which I don't want. I
think the assigning macro, was trivial , something gets right clicked as
I
recall

Help please!

Thanks!
Dean