How to removed the Dased Line using VBA
 

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.

How to removed the Dased Line using VBA
 

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.