Buttons

Can anyone tell me a few basics on how to put buttons into the spread sheet?
By appearance, and function. I am clueless on appearance. On function I
assume the only way to give function to the button Is via hyperlinks. Any
other way?
I would like to create floating buttons for the 12 months, so that where
ever I am on the spread sheet, I can click to another month which will
center itself and properly size the window if necessary.

Marc

Hi Marc,

You can make just about any object do anything with a macro.

First you need a macro. This can be very simple.

Turn on the visual basic toolbar View > Toolbars > Visual Basic
Click the "record" button.
Click a sheet tab to display a different sheet
Click the "record" button again to stop recording.

You've just recorded your first macro.

To run the macro switch to another worksheet. Then click the Run button on
the VB toolbar. Run your macro.

From the Run button you can edit the macro.

You can record most actions in Excel. It's not just a recorder that captures
key strokes. It actually writes visual basic code for you.

Now you need to associate the code with a button.

You can put any drawing object (from the drawing toolbar) or any picture
(there are lots of buttons in the clip gallery) onto a worksheet.

Control-click the object and choose Assign Macro and select your macro. Now
when you click the object your macro will run.

Hopefully you will find this whole process pretty easy to follow. There's a
tutorial on how to get into macros a whole lot more here:
Microsoft Excel for Macintosh
Visual Basic for Applications 101
<http://support.microsoft.com/default.aspx?scid=/support/macexcel/content/Ma
cVBA/MacVBA.asp>

-Jim

--
Jim Gordon
Mac MVP
**Everyone is encouraged to post answers to any unanswered questions
whenever you see one that you know the answer to.


On 5/4/04 11:22 PM, in article BCBDD621.5DF5%harmonz@mail.exclude-this.com,
"Marc Harmon" <harmonz.RemoveThis@mail.exclude-this.com> wrote:

> Can anyone tell me a few basics on how to put buttons into the spread sheet?
> By appearance, and function. I am clueless on appearance. On function I
> assume the only way to give function to the button Is via hyperlinks. Any
> other way?
> I would like to create floating buttons for the 12 months, so that where
> ever I am on the spread sheet, I can click to another month which will
> center itself and properly size the window if necessary.
>
> Marc
>