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

  • Thread starter Newbie seeks quick answer!
  • Start date
N

Newbie seeks quick answer!

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]...
 
N

Newbie seeks quick answer!

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

Easiest Way To Insert an Activity (Task) 0
One successor to multiple tasks 0
Print order of TriFold - Publisher 365 0
Scroll does not show preview 0
Office 2010, background images do not appear in print preview nor print 0
Every New Tasks Wants to Start in the Future 1
Office 2007 Apps - Printing all graphics mirrored - Text Normal 0
Page number and other formatting problem 2

Top