This has been asked, but not answered...
I'm not sure if this answers your question, but it may be helpful.
If you display page breaks, it looks like a border on the worksheet, in that
it delineates the printed area with a dashed line. You can automatically
show page breaks on all worksheets within a workbook by pasting the following
subroutine into a module of the workbook.
Sub Auto_Open()
Dim wksht As Worksheet
For Each wksht In Worksheets
wksht.DisplayPageBreaks = True
Next wksht
End Sub
"Kycajun" wrote:
I am needing to set a page border in excel. If I just draw a border around
the whole page, it works, until I have to go back and insert a record later.
Obviously it moves everything down, including the drawn border. What I need
is to basically have a permanent border around a set print area. Can this be
done? I have searched this topic and it has been asked, but not clearly
answered. I know you geniuses know the answer!!! Thanks!
|