Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection Gets Removed!! | Excel Discussion (Misc queries) | |||
Duplicate value are not being removed | Excel Programming | |||
Removeing the Grand Total Line when subtotals are removed | Excel Discussion (Misc queries) | |||
UserForm1 not getting removed using VBA | Excel Programming | |||
Toolbar cannot be removed | Setting up and Configuration of Excel |