Excel Page Borders

Posted on 2009-04-28
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

    < 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

    I could not find an answer to this, so I decided to change my report coming out of excel.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now