How to removed the Dased Line using VBA

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Dashed line formatting 0
Outlook Remove To and CC from Outlook template 1
How to remove dashes in Social Security number 15
Word Removing unwanted "lines" within a MS Word 10 table 1
Displaying zeros in cells 2
Removing unwanted "lines" within a MS Word 10 table 2
display message box in excel(2003) using VBA word(2003) 0
Is there a function for this.... 3

Back
Top