create a button and assign a macro

[Dean]

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

[Paul B]

Dean, view, toolbars, forms, click on the button then click on your sheet,
the assign macro box will then come up, pick the one you want
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dean" <[email protected]> wrote in message
news:[email protected]...
>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
>

[Dave Peterson]

Show the Forms toolbar.
Use the button from there.
You can assign the macro right after you create the button or rightclick on the
button and select Assign macro.

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

--

Dave Peterson

[Gord Dibben]

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" <[email protected]>
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
>

[Dean]

Thank you all.

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> 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" <[email protected]>
> 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
>>
>

[Paul B]

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dean" <[email protected]> wrote in message
news:[email protected]...
> Thank you all.
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:[email protected]...
>> 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" <[email protected]>
>> 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
>>>
>>
>
>

[Jim Thomlinson]

In Excel you want to make the forms toolbar visible. From this toolbar you
can grab the button icon and drag it onto you spreadsheet. Once added you
will be prompted to rename the button and assign a macro to it.
--
HTH...

Jim Thomlinson


"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
>
>
>

[Dean]

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" <[email protected]> wrote in message
news:[email protected]...
> Thank you all.
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:[email protected]...
>> 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" <[email protected]>
>> 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
>>>
>>
>
>