Buttons

[Marc Harmon]

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

 

[Jim Gordon MVP]

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