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?
|