If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to start Excel in Print Preview. What's the quickest way?
I want to start Excel in Print Preview. What's the quickest way?
|
#2
|
|||
|
|||
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.com "Newbie seeks quick answer!" Newbie seeks quick wrote in message ... I want to start Excel in Print Preview. What's the quickest way? |
#3
|
|||
|
|||
I want to start Excel in Print Preview. What's the quickest way?
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 "Newbie seeks quick answer!" wrote: I want to start Excel in Print Preview. What's the quickest way? |
#4
|
|||
|
|||
I want to start Excel in Print Preview. What's the quickest wa
Go to Tools/Options/Edit and uncheck "Ask to update automatic links" Mike "Newbie seeks quick answer!" wrote: 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 "Newbie seeks quick answer!" wrote: I want to start Excel in Print Preview. What's the quickest way? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook today should show tasks based on Start Date, not due date | Rose | General Discussion | 10 | October 9th, 2005 03:14 AM |
Excel 2003 Print Issue | TheRobsterUK | General Discussion | 2 | September 26th, 2005 04:59 PM |
One spreadsheet cell won't print but shows up in print preview? | Sally | General Discussion | 1 | May 26th, 2005 07:06 PM |
I'm having a problem with print preview in Excel XP. | Composto | General Discussion | 1 | October 11th, 2004 11:41 PM |
Bug: print preview in form datasheet with server filter on crashes access (ADP A2002 SP3) | Eric Cárdenas [MSFT] | Using Forms | 4 | June 24th, 2004 08:38 AM |