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 / Programming / May 2008

Tip: Looking for answers? Try searching our database.

How to removed the Dased Line using VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BJ - 29 May 2008 21:33 GMT
Currently, I am working on an Excel template. there is a button created for
user to print the template out.

the problem is after user printed the template, there is a dased line
showing in the spreadsheet. is that possible that the dashed line can be
removed using VBA code? or are there any optios out there that can be
checked/unchecked to pretend showing this dashed line?

thank you for any tips.
JLGWhiz - 29 May 2008 22:45 GMT
The dashed line that you see after printing is the automatic page breaks that
Excel sets.  To remove them, click Tools>Options>View and uncheck the
PageBreaks box.

> Currently, I am working on an Excel template. there is a button created for
> user to print the template out.
[quoted text clipped - 5 lines]
>
> thank you for any tips.
 
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.