Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Command Button for Macro on the Toolbar
Hi fellow Excel Users
I have a couple of questions I know how to create a command button using The Control Toolbox 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Command Button for Macro on the Toolbar
Hi Jnr
1. Choose ToolsMacrorecord macro press the stop button when finished recording or choose ToolsMacroStop Recording. Right-click the command button choose Assign MAcro and click your macro. 2. If you get the command button to sit on the Toolbar it will be on every time Excel is opened and if you click it the macro will not work so I do Not advise to to do this. When you are more experienced find out about adding Menus or Tool Bars through VB. There are routines for adding Menus/toolbars and unloading them when the Workbook closes or hiding them when when the workbook containing the code is not the active book. Regards peter 1. How do I record a macro and assign it to this command button 2. How do I get the command button to sit on my toolbar. Many thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create a command box fora macro to be stored on my toolbar | New Users to Excel | |||
Run Macro from Command Button | Excel Discussion (Misc queries) | |||
Assign a macro to a command button | Excel Discussion (Misc queries) | |||
Assigning a macro to a command button | Excel Discussion (Misc queries) | |||
Destroy command button with a Macro? | Excel Discussion (Misc queries) |