I want to start Excel in Print Preview. What's the quickest way?

C

Chip Pearson

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
[email protected]> wrote in message
news:[email protected]...
 
G

Guest

WoW & thanks!! Took me a few minutes - I'm soooo newbie ... for those that
don't know ... you write a small macro script in VBA ... then reset security
settings to allow macros to run ... BUT ... now I want to have this
automatically ... avoid the Update Links message (cause it's linked to other
workbooks) ... any help per chance? FYI ... the 'red wine' DIDN'T help me
.... but now I got it ...

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Print from preview 2
Excel Borders not printing in Excel 8
saving an excel "print preview" view 3
Quickest and easiest way to migrate old "Include" code to aspx 2
where is the PRINT command in Excel in Vista? 2
Quickest Way to Indent all Paragraphs 3
Where is Preview? 3

Top