#Hide page break linein word code

FooterMargin = Application.InchesToPoints(0.5) HeaderMargin = Application.InchesToPoints(0.5) BottomMargin = Application.InchesToPoints(1) TopMargin = Application.InchesToPoints(1) RightMargin = Application.InchesToPoints(0.75) LeftMargin = Application.InchesToPoints(0.75) Note that this snippet is from the sheet that correctly does not show the page breaks: Public Function cmlapi_Set_To_Landscape()

#Hide page break linein word code

It sounds like something in this code snippet is preventing them from showing up on this spreadsheet. These are the lines I am trying to remove: Note that the variable str_Worksheet_Name works in many other lines in the code, example: ActiveWorkbook.Worksheets(str_Worksheet_Name).Cells(1, 1).Select correctly selects cell A1 on the desired worksheet. My most reasonable use of this property has been:ĪctiveWorkbook.Worksheets(str_Worksheet_Name).DisplayPageBreaks = False Either I'm using it incorrectly, or it is not the correct setting. I've tried several different variations and applications of DisplayPageBreaks = False. Most of the advice on the internet points toward the options in Excel via the GUI, which is not an option. I have not been able to find a difference in the code that gives reason to this. Both are large enough to extend past one page. When running two different (though similar) spreadsheets on my local box without manually changing any options in Excel, one shows dotted grey lines on the page breaks (see image below) and one does not. We have a collection of ODBC spreadsheets generated via VBA. How do you remove grey dotted line page breaks (not the blue ones) from an Excel sheet using VBA code?