ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I link a macro to a customized icon button? (https://www.excelbanter.com/excel-programming/352870-how-do-i-link-macro-customized-icon-button.html)

DavidMollish

How do I link a macro to a customized icon button?
 
I have automated a few forms and have set up macros. I want to create an
icon button for someone push to print the correct set of forms. I am curious
how to link an icon button displayed on my spreadsheet to each of the
different macros.

I would appreciate your help.

Dave Peterson

How do I link a macro to a customized icon button?
 
If you use controls from the Forms toolbar or shapes from the Drawing toolbar,
you can just rightclick on that control/shape and choose assign macro.

Make sure you put your macros in a general module.

DavidMollish wrote:

I have automated a few forms and have set up macros. I want to create an
icon button for someone push to print the correct set of forms. I am curious
how to link an icon button displayed on my spreadsheet to each of the
different macros.

I would appreciate your help.


--

Dave Peterson


All times are GMT +1. The time now is 09:26 AM.

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