Buttons in worksheets

  • Thread starter Thread starter Silvabod
  • Start date Start date
S

Silvabod

Now have Excel 2003 (progress?)
In Excel 97, used to be able to create a button in a worksheet and assign a
macro to it

Seems no longer possible in Excel 2003. All I can find is "add new button to
toolbar" in the "help" - I want it in the worksheet.
Has this functionality gone, if not, please point me to the instructions (or
give step by step on "how to" ?
I'm a relative novice, long out of practice, only doing "fun" things in
retirement.
Silvabod
 
Silvabod said:
.. In Excel 97, used to be able to create a button
in a worksheet and assign a macro to it
Click to expand...

... FWIW, the behaviour above is when we draw a button from the Forms toolbar
(Forms toolbar activated via: View > Toolbar > Forms)
 
Max, Mangesh, thanks for the responses. Perhaps I've not made myself clear
(or I am mis-understanding)

I do not want a "toolbar". I want a single stand-alone button in the body of
a worksheet, as a "clickable" object (for example, in cell area C3).
Used to be able to do that via the "drawing" toolbar (and "size" it to
accommodate the button label text, then assign a macro to it) if my fading
memory is correct. It's several years now since I retired, New Excel is
vastly different to what I remember, though it's "help" is just as
uninformative for simple things like this (not even in the index, except as
"toolbar")
Silvabod.
 
Yes, that's what they are trying to tell you, though without much detail
;) Turn on the forms toolbar, then from there click on the "button"
button (fourth one I think). Now click and drag on your worksheet to
define where you want the button to go. You will then see a dialogue
allowing you to assign an existing macro, record a new one, or write a
new one in the VBA editor.

HTH

Mark

-----Original Message-----
From: Silvabod [mailto:[email protected]]
Posted At: 10 October 2005 11:11
Posted To: microsoft.public.excel
Conversation: Buttons in worksheets
Subject: Re: Buttons in worksheets


Max, Mangesh, thanks for the responses. Perhaps I've not made myself
clear (or I am mis-understanding)

I do not want a "toolbar". I want a single stand-alone button in the
body of a worksheet, as a "clickable" object (for example, in cell area
C3).
Used to be able to do that via the "drawing" toolbar (and "size" it to
accommodate the button label text, then assign a macro to it) if my
fading memory is correct. It's several years now since I retired, New
Excel is vastly different to what I remember, though it's "help" is just
as uninformative for simple things like this (not even in the index,
except as
"toolbar")
Silvabod.
 
Mark, Easy (when you know how!)
Thanks a lot for the patient explanation.
Silvabod.
Mark R Penn said:
Yes, that's what they are trying to tell you, though without much detail
;) Turn on the forms toolbar, then from there click on the "button"
button (fourth one I think). Now click and drag on your worksheet to
define where you want the button to go. You will then see a dialogue
allowing you to assign an existing macro, record a new one, or write a
new one in the VBA editor.

HTH

Mark

-----Original Message-----
From: Silvabod [mailto:[email protected]]
Posted At: 10 October 2005 11:11
Posted To: microsoft.public.excel
Conversation: Buttons in worksheets
Subject: Re: Buttons in worksheets


Max, Mangesh, thanks for the responses. Perhaps I've not made myself
clear (or I am mis-understanding)

I do not want a "toolbar". I want a single stand-alone button in the
body of a worksheet, as a "clickable" object (for example, in cell area
C3).
Used to be able to do that via the "drawing" toolbar (and "size" it to
accommodate the button label text, then assign a macro to it) if my
fading memory is correct. It's several years now since I retired, New
Excel is vastly different to what I remember, though it's "help" is just
as uninformative for simple things like this (not even in the index,
except as
"toolbar")
Silvabod.





Silvabod said:
Now have Excel 2003 (progress?)
In Excel 97, used to be able to create a button in a worksheet and
assign a macro to it

Seems no longer possible in Excel 2003. All I can find is "add new
button to toolbar" in the "help" - I want it in the worksheet.
Has this functionality gone, if not, please point me to the
instructions (or give step by step on "how to" ?
I'm a relative novice, long out of practice, only doing "fun" things
in retirement.
Silvabod
Click to expand...


--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.13/126 - Release Date:
09/10/2005
Click to expand...
 
Getting not only old, but dyslexic? Missed that! (still bogged down by the
unhelpful Help in Excel, rivetted on "toolbars")
Thanks again!
Silvabod.
 
It was perhaps just a little too succinct ;) With the FWIW prefix and the
snipped text, I read it as correcting the description of the old Excel 97
behaviour, rather than giving instructions for doing it in Excel 2003 ;)

But I'm not criticising - I only replied because it was obvious that
Silvabod had misunderstood what you were telling him :)

Mark
 
Back
Top