The dashed line that you see after printing is the automatic page breaks that
Excel sets. To remove them, click ToolsOptionsView and uncheck the
PageBreaks box.

"BJ" wrote:

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.