Excel Page Borders

Posted on 2009-04-28
Medium Priority
Last Modified: 2013-11-10
I have searched and searched with little success for a simple VBA script that will add page borders to an excel printed page, similar to the line draw used in Access.

It should be rather simple to just add a border with code irregardless of XL cell content or printed range.

Has anyone seen this, or can this be done?
Question by:DougDodge
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24289100

< similar to the line draw used in Access.>
The lines you can draw in Access can be "used as" borders.
They are not borders themselves, per se.

You can use the "Line" tool from the drawing toolbar in Excel, to do the same thing.
Or better yet, just use the Rectangle tool and draw a rectagle around your area and then set the transparency of the Rectangle to 100%



Accepted Solution

DougDodge earned 0 total points
ID: 24329808
I could not find an answer to this, so I decided to change my report coming out of excel.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question