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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbie seeks quick answer! - 02 Jan 2006 23:16 GMT

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

Reply to this Message

Chip Pearson - 02 Jan 2006 23:19 GMT

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

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

Signature

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

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

Reply to this Message

Newbie seeks quick answer! - 02 Jan 2006 23:58 GMT

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

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

Reply to this Message

Mike K - 03 Jan 2006 18:27 GMT

Go to Tools/Options/Edit and uncheck "Ask to update automatic links"

Mike

> 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
[quoted text clipped - 6 lines]
>
> > I want to start Excel in Print Preview. What's the quickest way?

Reply to this Message