Prevent Display of PageBreaks before opening a Workbook - VBA

[colmmc]

Hi all,

I have 300 spreadsheets that have 10 worksheets, each opening on PageBreak view. This slows down the opening of each spreadsheet. From ~42 seconds when displayed to 3 or 4 seconds without.

This slows down my VBA code by a similar factor. I'm trying to figure out how to disable this in some way before opening the file. Most coding examples online are applicable when the file is already open.

Any ideas?


Colm

 

[colmmc]

If there is a way in VBA to set the default view when opening a spreadsheet that would work too.