ExcelBanter - Detect page break preview

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Detect page break preview (https://www.excelbanter.com/excel-programming/403203-detect-page-break-preview.html)

ward376

Detect page break preview

How can I detect whether a sheet is in page break preview?

Thanks!
Cliff Edwards

Jim Cone

Detect page break preview

If ActiveWindow.View = xlPageBreakPreview then
'you are in it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"ward376"
wrote in message
How can I detect whether a sheet is in page break preview?
Thanks!
Cliff Edwards

ward376

Detect page break preview

Thanks!

All times are GMT +1. The time now is 10:14 PM.