PC Review


Reply
Thread Tools Rate Thread

Detect page break preview

 
 
ward376
Guest
Posts: n/a
 
      24th Dec 2007
How can I detect whether a sheet is in page break preview?

Thanks!
Cliff Edwards
 
Reply With Quote
 
 
 
 
Jim Cone
Guest
Posts: n/a
 
      24th Dec 2007

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
 
Reply With Quote
 
ward376
Guest
Posts: n/a
 
      24th Dec 2007
Thanks!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a page in Page Layout View or Page Break Preview tanner.robin@gmail.com Microsoft Excel Discussion 1 6th Jun 2008 02:52 PM
change and/or remove page number watermark in page break preview =?Utf-8?B?anVnYQ==?= Microsoft Excel Misc 2 25th Dec 2006 10:15 AM
print preview v page break preview =?Utf-8?B?U2FtQg==?= Microsoft Excel Misc 0 16th Nov 2006 05:09 PM
Hiding the page number in page break preview background. =?Utf-8?B?SSBuZWVkIGNvZmZlZSwgd2FrZSBtZSB1cCE=?= Microsoft Excel Misc 0 15th May 2006 10:32 AM
Detect page break settings =?Utf-8?B?SlJfMDYwNjIwMDU=?= Microsoft Excel Worksheet Functions 0 26th Jan 2006 02:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:38 AM.