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.