Print Dialog Box
 

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?

Print Dialog Box
 

Hi Ashman,

Try:

Application.dialogs(xlDialogPrint).Show

---
Regards,
Norman



"Ashman" wrote in message
...
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?

Print Dialog Box
 

Many thanks, that worked a treat.

Regards

Ashman

"Norman Jones" wrote:

Hi Ashman,

Try:

Application.dialogs(xlDialogPrint).Show

---
Regards,
Norman



"Ashman" wrote in message
...
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?