Icon in menue to start macro
 

How to make a macro start when I click an icon (print) in the menue? I
have written an macro starting an UserForm where it is possible to
choose what should be written out. I want this macro to start instead
of the standard printing-out when the "print-icon" is clicked.

Arne Lindberg


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Icon in menue to start macro
 

View | Toolbars | Customize

File | Print (right-click) | Assign Macro

--

Vasant


"Arne Lindberg" wrote in message
...

How to make a macro start when I click an icon (print) in the menue? I
have written an macro starting an UserForm where it is possible to
choose what should be written out. I want this macro to start instead
of the standard printing-out when the "print-icon" is clicked.

Arne Lindberg


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/