VB code to open Print window
 

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

VB code to open Print window
 

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

VB code to open Print window
 

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

VB code to open Print window
 

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

Application.Dialogs(xlDialogPrint).Show



Thanks!

VB code to open Print window
 

"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