View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Chip Pearson
 
Posts: n/a
Default I want to start Excel in Print Preview. What's the quickest way?

Put the following in the ThisWorkbook code module of your
workbook.

Private Sub Workbook_Open()
ActiveSheet.PrintPreview enablechanges:=True 'or false
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Newbie seeks quick answer!" <Newbie seeks quick
wrote in message
...
I want to start Excel in Print Preview. What's the quickest way?