ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I clear Print Preview? (https://www.excelbanter.com/excel-programming/406778-how-do-i-clear-print-preview.html)

Charlie

How do I clear Print Preview?
 
Hi,

When I do a Print Preview it places dashed lines down the column grid lines
where the sheet will be split. No problem, but how do I clear those dashed
lines from the sheet view when I no longer need to see them?

TIA,
Charlie

JE McGimpsey

How do I clear Print Preview?
 
ONe way:

ActiveSheet.DisplayPageBreaks = False


In article ,
Charlie wrote:

Hi,

When I do a Print Preview it places dashed lines down the column grid lines
where the sheet will be split. No problem, but how do I clear those dashed
lines from the sheet view when I no longer need to see them?

TIA,
Charlie



All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com