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 / March 2005

Tip: Looking for answers? Try searching our database.

Thick borders adjust automatically to print range?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fred Holmes - 18 Mar 2005 16:31 GMT
The "active" region of my worksheet has thick borders around the
periphery of the region, and thin cell borders everywhere inside the
region.  When the active region is long and breaks across multiple
pages, the internal borders that appear at the page break remain thin.
I find myself manually changing these borders from thin to thick so
that each page has has a thick border around the periphery of that
page itself.  Is there any way to make this occur automatically,
especially as rows may be inserted or deleted and the page break moves
to a different row boundary?

Thanks in advance for any help,

Fred Holmes
Jim Cone - 18 Mar 2005 21:01 GMT
Fred,

It could get very messy trying to do this with VBA.
It might be better to go to PageBreak Preview and
select all of the cells at the bottom of each page,
(using the Ctrl key).  Then you only have to use the
format command just once.

Regards,
Jim Cone
San Francisco, USA

> The "active" region of my worksheet has thick borders around the
> periphery of the region, and thin cell borders everywhere inside the
[quoted text clipped - 7 lines]
> Thanks in advance for any help,
> Fred Holmes
 
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.