Display button
Hi Jenni,
You can create a button from the Forms menu (click ViewToolbarsForms 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!
|