| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I Create A Button On the Top Tool Bar?
I give that a try...
Thanks, <Jeff "John Keith" wrote in message ... Just assign a shortcut key to the macro... On the "Macro" menu select "options" and then assign a CRTL+key to use. To use the command bar option and assign the ALT key to be part of the sub-menu item, like alt+f for FILE, then alt+s for save... take a look at the controls("???").shortcuttext property This will let you assign the letter when combined with ALT that will run the .OnAction assigned macro. It will show the "_" for that letter in the menu text too. -- Regards, John "Jeff W." wrote: I have created a selection that goes there on open and has a drop down menu, then is removed on close, but Is it possible to create a button named "Update" that can run a sub when you select it? Right now if I press [ALT] F it will drop down my File menu It would be nice If I could press [ALT] U and run the macro associated with the newly create button Does anyone have any ideas or suggestions on this? Thanks, Jeff W. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to add a redo button on my tool bar | New Users to Excel | |||
| The button on my tool bar won't display | Excel Discussion (Misc queries) | |||
| tool bar button | New Users to Excel | |||
| Adding Button to Tool Bar | Excel Discussion (Misc queries) | |||
| Excel's draw tool to create a Macro Button | Excel Programming | |||
Threaded Mode
