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?
|
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? |
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? |
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? |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com