ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating Buttons (https://www.excelbanter.com/excel-programming/325103-creating-buttons.html)

Brian

Creating Buttons
 
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?

Bob Phillips[_6_]

Creating Buttons
 
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?




OnceTall

Creating Buttons
 
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



All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com