Hello,

Just a quick one. Does anyone know what the VB code is to open the
Print box (ie when you click FilePrint)

thanks,

Michael

Application.Dialogs(xlDialogPrint).Show

--

HTH

RP
(remove nothere from the email address if mailing direct)


"OscarC" wrote in message
...
Hello,

Just a quick one. Does anyone know what the VB code is to open the
Print box (ie when you click FilePrint)

thanks,

Michael

On Mon, 6 Dec 2004 22:35:13 -0000, "Bob Phillips"
wrote:

Application.Dialogs(xlDialogPrint).Show



Thanks!

Application.Dialogs(xlDialogPrint).Show

Hope this helps

"OscarC" wrote:

Hello,

Just a quick one. Does anyone know what the VB code is to open the
Print box (ie when you click FilePrint)

thanks,

Michael

"OscarC" wrote in message
...
Hello,

Just a quick one. Does anyone know what the VB code is to open the
Print box (ie when you click FilePrint)

thanks,

Michael

Hi Michael

Sub prinit ()

ActiveWindow.SelectedSheets.PrintPreview

End Sub

n10