Print Dialog Box pre-select choices

[briannakmg]

I am looking to have the print dialog box pop up for the users of my spreadsheet and I need the "selection" radio button under "Print What" to be selected instead of "Active Sheet(s)". I've already got everything selected I just don't think the users will remember to choose "selection" when they print.

 

[Jaafar Tribak]

This should work :

Place this in a standard module in your project :

Public Declare Function SetTimer _
Lib "user32" _
    (ByVal hwnd As Long, _
    ByVal nIDEvent As Long, _
    ByVal uElapse As Long, _
    ByVal lpTimerFunc As Long) As Long
 
Public Declare Function KillTimer _
Lib "user32" _
    (ByVal hwnd As Long, _
    ByVal nIDEvent As Long) As Long
    
Public lTimerID As Long
 
Public Sub TimerProc()
 
    KillTimer 0, lTimerID
    SendKeys "%n", True
 
End Sub

Place this in the workbook module :

Private Sub Workbook_BeforePrint(Cancel As Boolean)
 
    lTimerID = SetTimer(0, 0, 1, AddressOf TimerProc)
 
End Sub

Regards.

 

[RoryA]

You can also use:

application.Dialogs(xlDialogPrint).Show ,,,,,,,,,,,1

 

[Jaafar Tribak]

You can also use:

application.Dialogs(xlDialogPrint).Show ,,,,,,,,,,,1

Rory,

The arguments of dialogs are not documented on help files . How/where did you find out about them ?

Thanks ahead.

 

[RoryA]

Jaafar,
They are basically the same arguments you would use with the old XLM macro functions, so if you get hold of the Macrofun.hlp help file, you can usually figure out the arguments for most dialogs - they're in the same order, thankfully!
Edit: you can hopefully still get the file here.

 

[Jaafar Tribak]

Jaafar,
They are basically the same arguments you would use with the old XLM macro functions, so if you get hold of the Macrofun.hlp help file, you can usually figure out the arguments for most dialogs - they're in the same order, thankfully!
Edit: you can hopefully still get the file here.

Installed the help files - great info . Will be exploring those XLM macros.


PRINT(range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection)

Many thanks.

 

[briannakmg]

I knew it was something simple, just couldn't find anything in the help menus on how many commas I would need!

Thanks so much,
Brianna