Make a button or menu selection

[RST Engineering \(jw\)]

Is it possible to make a custom button (icon) on a toolbar or add a custom
menu selection to run a macro from toolbar or menu?

Jim

 

[Dave Peterson]

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

 

[meh2030]

Is it possible to make a custom button (icon) on a toolbar or add a custom
menu selection to run a macro from toolbar or menu?

Jim

Jim,

Yes. Follow these steps for Excel 2003:

- Right click a toolbar and click "Customize"
[You can now do a number of things from here]
- Create a new toolbar: "Toolbars" page | "New"
- Add native Excel buttons: "Commands" page | select a "Category" |
drag and drop the a command from "Commands"
- Add a custom button: "Commands" page | select "Macros" from
"Category" | drag and drop the "Custom Button" from "Commands"
- Add a menu: "Commands" page | select "New Menu" from "Category" |
drag and drop the "New Menu"

Once you drag and drop something, you can then right click what you
dropped and change the properties (including the name, an accelerator
key, etc.) and assign a macro. If you want to delete something,
simply drag it off the toolbar and drop it into an empty space (such
as the spreadsheet); the item will simply disappear.

Best,

Matthew Herbert