ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do i program a macro for print view (https://www.excelbanter.com/excel-programming/378811-re-how-do-i-program-macro-print-view.html)

Don Guillett

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?





All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com