ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I create a button, that is linked to a macro (start)? (https://www.excelbanter.com/excel-programming/376000-how-can-i-create-button-linked-macro-start.html)

dcik

How can I create a button, that is linked to a macro (start)?
 
....

Allllen

How can I create a button, that is linked to a macro (start)?
 
1) create your macro (probably using the macro recorder). Run it a few times
though Tools Macro so that you are sure it does what you want.

2) Edit Toolbars Forms

3) On the forms toolbar, select the command button. Drag and drop it into
your sheet. Excel will ask you if you want to link it to a macro, so choose
the one you created above.
--
Allllen


"dcik" wrote:

...


Bob Phillips

How can I create a button, that is linked to a macro (start)?
 
Create your macro, drag a button off of the forms toolbar, and assign the
button to the macro when prompted.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dcik" wrote in message
...
...





All times are GMT +1. The time now is 04:42 AM.

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