Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: User ability to select printer

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Using the printout command, I don't see a way to allow the user to change his printer. Is there anyway to get the user to specify the printer or to change copies. I can see how to set the ammount of copies but I can't seem to figure out how to give the user an option (when his print command is disabled) to select the printer on a printout other than use a print preview option.

    John

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Click file
    click print

    see the white section middle top ish, to the right is a arrow/drop down click it. A box apperars that aallows prit selection to any printer is networked or whatever.

    Does this help or im misunderstood, sorry

    I guess in code try record it and set the network to that default printer, should record ok, but paper selection ie dula bin lazers or manual seems to be effected by the software attached to that printer as does dublex printing.

    MY fix is not to print at all, save as unique file name and save in dir made called PRINT and todays date and thend default excel to what printer and papers typr and location and all the rest and then print 1 or all saved docs.



    _________________
    Good Luck
    HTH

    Rdgs
    ==========
    Jack in the UK

    [ This Message was edited by: Jack in the UK on 2002-03-10 14:23 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try Application.Dialogs(xlDialogPrinterSetup).Show or more appropriately I think you want

    Application.Dialogs(xlDialogPrint).Show

    [ This Message was edited by: SamS on 2002-03-10 16:55 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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