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

  • Thread starter Thread starter Guest
  • Start date Start date
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]...
 
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
 
Go to Tools/Options/Edit and uncheck "Ask to update automatic links"

Mike
 
You must log in or register to reply here.

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 Way to Indent all Paragraphs 3
form objects - alignment problem after printing/preview 2
where is the PRINT command in Excel in Vista? 2
Print Preview Current Slide 1

Back
Top