ActiveSheet.DisplayAutomaticPageBreaks = False

On 11 jan, 19:47, Bryan44 wrote:
I have a completed dictator application in Excel 2003 and have discovered
some unique features of Excel I wasn't planning on. I've create a button
that shows/hides some embedded charts in a section of a worksheet that I open
and close with another command button. The show/hide command button I make
visible if the section is open and invisible when the section is closed. All
of this functionality works just fine until the end-user calls my VBA print
code. The code operates just fine but what happens post printing is that the
worksheet has dotted lines that appear like the lines you have after setting
the print area, which I indeed do during the print routines.

My question is, "is there a way to eliminate those from displaying in the
worksheet?"

Thanks a ton in advance for you help,

Bryan44