Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to create a button to allow me to click on this button and run a
macro. I am almost positive I know how to assign the macro, I just can't remember how to create the button in the first place. Can someone help? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
ToolsCustomize Tools Tab and check the Forms box. Now, from that new
toolbar, click the button icon, and then draw it on the worksheet. It will prompt for a macro to assign. -- HTH RP (remove nothere from the email address if mailing direct) "Brian" wrote in message ... I need to create a button to allow me to click on this button and run a macro. I am almost positive I know how to assign the macro, I just can't remember how to create the button in the first place. Can someone help? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can also assign the macro to any shape from the Drawing Toolbar.
(View...Toolbars...Drawing). Once you create the shape on your sheet, you right click it to assign your macro. OnceTall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Custom Buttons | Excel Discussion (Misc queries) | |||
creating buttons in worksheet | Excel Discussion (Misc queries) | |||
Creating Macro Buttons and formatting | Excel Discussion (Misc queries) | |||
creating buttons with a macro | Excel Programming | |||
Creating buttons using VBA | Excel Programming |