Thread: Display button

Hi! I am writing a macro that I want to attach to an excel-spreadsheet. The
visible part of the macro consists of a button and some text in some cells.
How do I write the code so that that the macro is "attached" to the
spreadsheet i.e. when you open the workbook you will see the button and the
text. I am a programming noivce so please write easy help!

Hi Jenni,

You can create a button from the Forms menu (click View>Toolbars>Forms then
click on the button icon and move your cursor to the sheet and click and drag
to size the button). When you place the button on your spreadsheet, you'll
be prompted to attach a macro which you'll be able to select from a list of
macros you've already created. If a button already exists on your
spreadsheet and you'd like to attach a macro to it (or change the currently
attached macro), right-click the button, then select "Assign macro..." and
choose the macro you'd like from the list.

"Jenni_Sweden" wrote:

> Hi! I am writing a macro that I want to attach to an excel-spreadsheet. The
> visible part of the macro consists of a button and some text in some cells.
> How do I write the code so that that the macro is "attached" to the
> spreadsheet i.e. when you open the workbook you will see the button and the
> text. I am a programming noivce so please write easy help!
>

Thank you. However when choosing the button as you described it I cannot
insert it into the spreadsheet. The cursor becomes invisible when moved
outside the Forms menu. Any clue?
--
I am very thankful for any fast assistance!


"Paul Mathews" skrev:

> Hi Jenni,
>
> You can create a button from the Forms menu (click View>Toolbars>Forms then
> click on the button icon and move your cursor to the sheet and click and drag
> to size the button). When you place the button on your spreadsheet, you'll
> be prompted to attach a macro which you'll be able to select from a list of
> macros you've already created. If a button already exists on your
> spreadsheet and you'd like to attach a macro to it (or change the currently
> attached macro), right-click the button, then select "Assign macro..." and
> choose the macro you'd like from the list.
>
> "Jenni_Sweden" wrote:
>
> > Hi! I am writing a macro that I want to attach to an excel-spreadsheet. The
> > visible part of the macro consists of a button and some text in some cells.
> > How do I write the code so that that the macro is "attached" to the
> > spreadsheet i.e. when you open the workbook you will see the button and the
> > text. I am a programming noivce so please write easy help!
> >

Jenni, what should happen is that the cursor turns into a cross. That's
fine, move the cross to wherever you'd like the button on your spreadsheet,
then left-click to locate the button to the sheet (don't let go off the
left-click button) and then you'll size the button by keeping your left-click
button pressed and dragging the cursor to the right and down (you'll see the
outline of the button as you do this). When the button is roughly as big as
you want, let go of your left-clicker. The button will appear and then
you'll be prompted to assign a macro to it.

"Jenni_Sweden" wrote:

> Thank you. However when choosing the button as you described it I cannot
> insert it into the spreadsheet. The cursor becomes invisible when moved
> outside the Forms menu. Any clue?
> --
> I am very thankful for any fast assistance!
>
>
> "Paul Mathews" skrev:
>
> > Hi Jenni,
> >
> > You can create a button from the Forms menu (click View>Toolbars>Forms then
> > click on the button icon and move your cursor to the sheet and click and drag
> > to size the button). When you place the button on your spreadsheet, you'll
> > be prompted to attach a macro which you'll be able to select from a list of
> > macros you've already created. If a button already exists on your
> > spreadsheet and you'd like to attach a macro to it (or change the currently
> > attached macro), right-click the button, then select "Assign macro..." and
> > choose the macro you'd like from the list.
> >
> > "Jenni_Sweden" wrote:
> >
> > > Hi! I am writing a macro that I want to attach to an excel-spreadsheet. The
> > > visible part of the macro consists of a button and some text in some cells.
> > > How do I write the code so that that the macro is "attached" to the
> > > spreadsheet i.e. when you open the workbook you will see the button and the
> > > text. I am a programming noivce so please write easy help!
> > >