Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command button to point to a macro
Hi everyone,
I'm trying to get a command button to point to a macro that I recently recorded and for some reason I'm having troubles. I'm sure there's part of the code in visual basic that I'm missing... Can anyone help me out? Thanks!!! mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command button to point to a macro
There are two ways to add command buttons to a sprdsht: from the VBA
Control Toolbox and from the Forms toolbar. I find the button from the Forms toolbar easiest to work with: when you invoke a button from Forms, you will be asked what macro you want to assign to this button. Afterwards you can right-click on the button and re-assign a different macro. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command button to point to a macro
If you want to add a button to an Excel toolbar, or create your own toolbar
with your own button(s), I can tell you how to do that. What kind of "troubles" are you having? Do you need to know how to start out putting the button on the toolbar, or how to map it to your macro, or how to put text on the button, or what? "mike the new guy" wrote: Hi everyone, I'm trying to get a command button to point to a macro that I recently recorded and for some reason I'm having troubles. I'm sure there's part of the code in visual basic that I'm missing... Can anyone help me out? Thanks!!! mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
Editing a simple macro | Excel Worksheet Functions | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |