software

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

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.comquot;Newbie seeks quick answer!quot; lt;Newbie seeks quick
gt; wrote in message
...
gt;I want to start Excel in Print Preview. What's the quickest way?
WoW amp; 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

quot;Newbie seeks quick answer!quot; wrote:

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


Go to Tools/Options/Edit and uncheck quot;Ask to update automatic linksquot;

Mike

quot;Newbie seeks quick answer!quot; wrote:

gt; WoW amp; thanks!! Took me a few minutes - I'm soooo newbie ... for those that
gt; don't know ... you write a small macro script in VBA ... then reset security
gt; settings to allow macros to run ... BUT ... now I want to have this
gt; automatically ... avoid the Update Links message (cause it's linked to other
gt; workbooks) ... any help per chance? FYI ... the 'red wine' DIDN'T help me
gt; ... but now I got it ...
gt;
gt; Steve
gt;
gt; quot;Newbie seeks quick answer!quot; wrote:
gt;
gt; gt; I want to start Excel in Print Preview. What's the quickest way?