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. |
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