I have a “Print button” in a UserForm. When hitting the button i want the “Print and Preview” dialog to show and “To”-“From” and “Number of copies” to be prefilled.
To open the “Print and Preview Dialog” I use this code, which works perfect:
I found this code to prefill the Print Dialog settings. Works perfect to.
Application.Dialogs(xlDialogPrint).Show , 1, 2, 3
I have tried to combine these two codes in a variety of ways, but with out luck.
Does anyone knows if this i doable?