View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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