Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / September 2007

Tip: Looking for answers? Try searching our database.

Dotted line surrounding print area

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben - 17 Sep 2007 14:14 GMT
When defining a print range either manually or with a macro, there remains on
the screen a dotted line around the edge of the printing area. It remains
there until the file is closed and re-opened. Is there any way i can get rid
of this outline. I've tried CutCopy=false in VBA but that does not do it.

Thank you
Franz Verga - 17 Sep 2007 15:03 GMT
Nel post:69EA244A-FA2C-424A-AC3B-CC1AD4275E1B@microsoft.com,
Ben <Ben@discussions.microsoft.com> ha scritto:
> When defining a print range either manually or with a macro, there
> remains on the screen a dotted line around the edge of the printing
[quoted text clipped - 3 lines]
>
> Thank you

Hi Ben,

from menu Tools, Option, select tab View then in the section Window options
uncheck "Automatic page breaks".

Signature

(I'm not sure of  names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Ben - 17 Sep 2007 15:56 GMT
Thank you. that solved the problem

> Nel post:69EA244A-FA2C-424A-AC3B-CC1AD4275E1B@microsoft.com,
> Ben <Ben@discussions.microsoft.com> ha scritto:
[quoted text clipped - 10 lines]
> from menu Tools, Option, select tab View then in the section Window options
> uncheck "Automatic page breaks".

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.