Any comments?
I have been doing an application.visible = False as part of my Excel apps
for years when users quit my apps. The reason is to seem to shutdown in a
snap rather than side there for 3 or 4 seconds running the closing routine.
Of course Excel takes the same amount of time to truly shutdown visible or
hidden (I assume). No bad side effects in 10 years so I swear by it. There
always could be some action you take in a closing macro that requires Excel
to be visible for some reason, but I haven't hit one.
Blocking the printing message box is a tough one. I don't know of a way to
do that.
--
Jim
"Chuckles123"
wrote in message
...
|
| Jim,
|
| Your post does eliminate the 1-second conventional Excel blank
| worksheet screen.
| However, I remember reading several posts on this site indicating bad
| things happen (like not being able to make Excel visible again) if
| macros did not contain matched pairs of App.Visible=F/T. Any
| comments?
|
| Also, as I implied in my first sentence, I made your suggested
| deletion. When stepping through my code (using F8), it works
| perfectly. However, at full speed, it is doing some strange things
| like sending out e-mails based on both results of an If statement. I
| will continue to research.
|
| Chuckles123
|
| Any hopes of eliminating the 2-second 'Handshaking' screen?
|
|
| --
| Chuckles123
| ------------------------------------------------------------------------
| Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
| View this thread:
http://www.excelforum.com/showthread...hreadid=389166
|