Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Undo button in the context menu (right click menu) | Excel Programming | |||
how to make a menu selection in the same cell? | Excel Discussion (Misc queries) | |||
Create floating button based on button click in menu | Excel Programming | |||
Using a macro to make selection in a drop down menu | Excel Programming |