center print dialogue box

[rjplante]

I have a three monitor setup and I use the center monitor to display my excel workbook. When I use VBA to call the print dialogue box, it is skewed to the right which is most likely the center of the three monitors. Is there a way to center the print dialogue box? I am using the line below to display the dialogue box, I just do not know how to center it.

Application.Dialogs(xlDialogPrint).Show

 

[Micron]

Controlling application dialogs can be daunting. This might provide some insight

Can I control the position of a filedialog window?

We have recently changed to dual monitors and annoyingly when the Excel application is expanded across both screens, any filedialog window that is invoked by a macro sits right in the middle of the split. I can control the position of userforms with the .Top and .Left form properties but don't...

www.mrexcel.com

Often, the last position of a dialog when closed dictates where it opens next time it's called. Try opening it then dragging it onto the desired screen before you close it. Perhaps you did that already?

 

[rjplante]

You are correct. Thanks for the super easy fix. Those are my favorite.

 

[Micron]

Glad I could help, & thanks for the recognition!