View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ashman Ashman is offline
external usenet poster
 
Posts: 35
Default 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?