Make a button or menu selection
 

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

--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle

Make a button or menu selection
 

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

"RST Engineering (jw)" wrote:

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

--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle

--

Dave Peterson

Make a button or menu selection
 

On Apr 13, 10:30*am, "RST Engineering \(jw\)"
wrote:
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

--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
* * * * --Aristotle

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