Nicer buttons

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Where can I get or create my own, nicer buttons for my spreadsheet to
fire up a macro!
Regards.
 
If you're placing them on a worksheet, maybe you can use a control from the
drawing toolbar or any old picture that you add to the worksheet.
 
Hi,

I recommend putting buttons on the toolbars, that way you can see them
anywhere in your files, not just in certain areas of the active sheet. If
that is the case you can copy button pictures from any button in any Microsft
App and paste it your Excel custom button. You can also design your own
button pictures by choosing View, Toolbars, Customize, and then
right-clicking the button and choosing Edit button image. Further there are
free (not free) button gallaries available on the internet.

If you are putting buttons in the spreadsheet, keep in mind you can use any
AutoShape to launch a macro and you can change there looks many ways. You
cah make them 3-D, add shadows, add text, change their color and even add any
picture from the internet.

With Form buttons you are rather limited.

With Control Toolbox buttons you can add a picture throught he Picture
property as well as other lesser changes.
 
1.Draw your custom shape from the draw tool bar.
2.Now select the shape on the sheet.
3.Right click on the shape and from the pop up select Assign Macro
4.Give macro name and click OK


Chris
 
Back
Top