ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hatched page break lines (https://www.excelbanter.com/excel-programming/292001-hatched-page-break-lines.html)

Hotbird[_2_]

Hatched page break lines
 
I inadvertently printed a page which is normally only displayed visually,
and now the page boundaries appear as hatched horizontal and vertical lines.
I have checked that there is no "Print_Area" selected for that sheet, but
have been unable to get rid of the unwanted lines. Is there an easy way to
remove them?



Tom Ogilvy

Hatched page break lines
 
Tools=Option, view tab, at the buttom uncheck PageBreaks. Just a guess at
what you mean hatched (I would choose dashed or dotted, more like -----) -
but I assume this will do it.

--
Regards,
Tom Ogilvy
"Hotbird" wrote in message
news:hXmZb.171$Z9.140@newsfe1-win...
I inadvertently printed a page which is normally only displayed visually,
and now the page boundaries appear as hatched horizontal and vertical

lines.
I have checked that there is no "Print_Area" selected for that sheet, but
have been unable to get rid of the unwanted lines. Is there an easy way

to
remove them?





Hotbird[_2_]

Hatched page break lines
 
Thanks Tom for your explanation. Have got one more little question. I
would like to show a tiny printer icon in a corner of my spreadsheet, (or on
a menubar) which can be switched on or off by program control to indicate
when I have the automatic print function selected.



"Tom Ogilvy" wrote in message
...
Tools=Option, view tab, at the buttom uncheck PageBreaks. Just a guess

at
what you mean hatched (I would choose dashed or dotted, more

ike -----) -
but I assume this will do it.

--
Regards,
Tom Ogilvy
"Hotbird" wrote in message
news:hXmZb.171$Z9.140@newsfe1-win...
I inadvertently printed a page which is normally only displayed

visually,
and now the page boundaries appear as hatched horizontal and vertical

lines.
I have checked that there is no "Print_Area" selected for that sheet,

but
have been unable to get rid of the unwanted lines. Is there an easy way

to
remove them?








All times are GMT +1. The time now is 06:46 PM.

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