View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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