Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Dialog Box | Excel Worksheet Functions | |||
Print Dialog box | Excel Discussion (Misc queries) | |||
excel print dialog | Excel Programming | |||
Print dialog | Excel Programming | |||
get information from Print dialog | Excel Programming |