Thread: print button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dominicb
 
Posts: n/a
Default print button


Good morning caveman

You can do this yourself, and learn about macros to boot.

Tools Macros Record new macro

Then hide the columns, print the reoprt and then unhide the columns.
When you have done click on the stop button. Then right click over the
menu bar and select the Forms toolbar. Using the button tool draw a
button and then assign a macro to it (it will probably be called
macro1).

Voila! A macro that can be called whenever you please!

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=486167