Print Dialog Box

[Guest]

I have a button on a page for printing, it formats the page correctly then
prints the page. I have inserted in a macro the page setup procedure (the
page will not vary in the furture), but I have included:

Application.dialogs(xlDialogPrint)

This I wanted to bring the print box up so the user can select there printer
and print the page.

It comes up with a Compiler Error message. I do not know why as I have used
a similar procedure for saving a spreadsheet.

Can anyone help me?

 

[Norman Jones]

Hi Ashman,

Try:

Application.dialogs(xlDialogPrint).Show

 

[Guest]

Many thanks, that worked a treat.

Regards

Ashman