+ Reply to Thread
Results 1 to 2 of 2

Option to let user select printer?

Hybrid View

wpattison Option to let user select... 05-03-2005, 11:05 AM
Leith Ross Hello wpattison, Here is... 05-03-2005, 03:56 PM
  1. #1
    Registered User
    Join Date
    04-26-2005
    Posts
    9

    Option to let user select printer?

    Is there a command to bring up the select printer/options menu instead of just sending the data to the default printer? Here is the code I am using now:

    Range("B12:BQ67").Select
    ActiveSheet.PageSetup.PrintArea = "$B$12:$BQ$67"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
    ActiveWindow.SelectedSheets.PrintOut

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello wpattison,

    Here is how to display the Print Dialog in Excel.

    Display Print DialogBox:
    RetVal = Application.Dialogs(xlDialogPrint).Show

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1