Ladies and Germs, lets hear it for SUB Workbook_BeforePrint

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Ladies and Germs, lets hear it for SUB Workbook_BeforePrint

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston TX
    Posts
    550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello,

    I'm using the Workbook_BeforePrint subroutine to manually print jobs as I must make adjustments to FOOTERS and the like.

    I ran into a snafu (above and beyond the PRINT PREVIEW issue in which the code kicks off even though you did not wish to print).

    Without the procedure in place, one can (from the Workseet Menu Bar) select FILE>PRINT and be prompted with a print dialog window.

    From there you can select a variety of print options.

    Unfortunately, the procedure in question WILL NOT prompt for print options from FILE>PRINT. This might cause the user to print gobs of stuff (if my sneaky VBA has its way).

    So, is there a way to call the window from VBA?

    Thanks most kindly

    [ This Message was edited by: bill on 2002-04-19 10:49 ]

    [ This Message was edited by: bill on 2002-04-19 10:50 ]

    [ This Message was edited by: bill on 2002-04-19 10:51 ]

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not quite sure what you're asking for here. Is it this you want?


    Application.Dialogs(xlDialogPrint).Show


  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston TX
    Posts
    550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    YES!!!!!!!


    thank you!!!!!

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
  •  

 

 
DMCA.com