Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2005

Tip: Looking for answers? Try searching our database.

Using application.visible

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
zkid - 27 Oct 2005 00:07 GMT
When I use application.visible = false and then turn it back on when the
macro has finished, the following occurs:

The window screen that appears is fine.  However, there is another document
that is created at the same time.  When I change windows to look at that
document, its view is messed up (the narrow print view bar at the bottom of
the document screen disappears and the document window cannot be scrolled).  
When I click the print preview button and close it, the view is then
"repaired."  I attempted to print preview it programmically at the end of the
code, but it makes no difference.  Any suggestions?

By the way, there are a lot of changes being made in the headers and
footers, so turning off screen updating doesn't make any difference - the
headers automatically turn it back on (and no, I cannot use the header range
object here - dealing with a lot of replacement of text and graphics -
thanks).
zkid - 27 Oct 2005 17:50 GMT
Never mind, I figured it out.  My ScreenUpdating and ScreenRefresh were on
the wrong lines.

> When I use application.visible = false and then turn it back on when the
> macro has finished, the following occurs:
[quoted text clipped - 12 lines]
> object here - dealing with a lot of replacement of text and graphics -
> thanks).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.