Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create buttons?
I am trying to make a menu in exel...
and I want buttons to click on to perform the macros I have made. So how do I make a costumize button? Click and drag to adjust the button... things like that... |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create buttons?
I prefer to use shapes/rectangle from the drawing toolbar.
viewtoolbarsdrawingselect and drag to ssright click lower right assign macroadd text,etc -- Don Guillett SalesAid Software "play4you" wrote in message ... I am trying to make a menu in exel... and I want buttons to click on to perform the macros I have made. So how do I make a costumize button? Click and drag to adjust the button... things like that... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create buttons?
ToolsCustomizeCommands.
Scroll down to Macros. Drag Custom Button to your Toolbar. Right-click on the button and you have some options. 1. Name the button. 2. Assign macro. 3. Edit button image. 4. Change button image. You have a limited number of choices. Download John Walkenbach's file Button Faces from here. http://www.j-walk.com/ss/excel/files/developer.htm Any of these can be dragged to your toolbar and have a macro assigned. Best method of assigning macros to buttons is to build the Toolbar when you open the workbook and delete it when you close. Do not make the changes to the existing toolbars. See Debra Dalgleish's website for Dave Peterson help on building "on the fly" toolbars and menus. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Wed, 22 Nov 2006 05:24:01 -0800, play4you wrote: I am trying to make a menu in exel... and I want buttons to click on to perform the macros I have made. So how do I make a costumize button? Click and drag to adjust the button... things like that... Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros AND Buttons | Excel Worksheet Functions | |||
Macros And Buttons | Excel Discussion (Misc queries) | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
How do I create charts that change source data automatically? | Charts and Charting in Excel | |||
Create a tabular control | Excel Discussion (Misc queries) |