View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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/