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?