How can I detect whether a sheet is in page break preview? Thanks! Cliff Edwards
W ward376 Dec 24, 2007 #1 How can I detect whether a sheet is in page break preview? Thanks! Cliff Edwards
J Jim Cone Dec 24, 2007 #2 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
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