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