LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Directing the Printing using a Macro

Within a self-written VB userform, how do i get the print dialogue box to
open by using a macro attached to a button. The VB macro
[Sheets("sheet1").Printout] only prints to the default printer but won't let
you select a printer to output towards. I want the user to be able to choose
which printer to print to AFTERr pressing my macro print button (akin to
pressing file/print... instead of pressing the print button on the toolbar -
cos these will all be turned off and hidden other than my userform.)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
directing cell contents dependent on its value Debi Excel Worksheet Functions 2 April 15th 10 09:58 AM
directing the sum of a cell to either of two cells depending on va Debi Excel Discussion (Misc queries) 3 April 15th 10 09:49 AM
Directing a Save As in VBA ngarland13 Excel Programming 4 September 1st 05 09:33 PM
Directing Users? Clint Keller[_2_] Excel Programming 2 May 28th 04 07:42 AM
Directing data to new worksheets sallie Excel Programming 5 December 31st 03 05:26 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"