View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default How do i program a macro for print view

I just recorded this...

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/5/2006 by Don Guillett
'

'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:=
_
True
End Sub

--
Don Guillett
SalesAid Software

"Glenn" wrote in message
...
I programmed this macro to print a page in my workbook. How can i modify
it
to let me view the page before I print it?