Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Application.Visible default changed?

Running Office Professional 2003, Windows XP Service Pack 2.

I have a reporting application, generated from Access and outputting
via automation to Excel. I have been relying on the fact that, when
creating a new Excel Application in code, the Visible property
defaults to "false". I can then lay out the data, and reset the
Visible property to "true" at the end, with the end result visible at
that time.

That approach has been working well, until very recently. Suddenly,
the new Excel Application is turning up with the Visible property set
to "true" out of the box, and all of the ugly detail of the process is
visible. I have made no changes on my workstation that could account
for it. Rebooting doesn't fix the problem. Everything works as it
should on another workstation, running Office XP.

The only explanation that comes to mind is that Microsoft has pushed
out an update that has changed the default behaviour, but that seems
kind of unlikely, and searching brings up nothing on it. Ok, I can
set the property to "false" in code, which works (although it causes
Access to lose focus, with nothing replacing it, which looks
disconcerting).

I am a bit disturbed by this mysterious change in Excel behaviour, and
would be glad of any suggestions about cause etc.

TIA

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.Visible = False SimonB Excel Discussion (Misc queries) 1 October 15th 06 01:10 PM
Application.visible........ Duncan[_5_] Excel Programming 8 June 27th 06 10:56 AM
Application Visible Frank Excel Programming 6 December 20th 05 08:01 PM
Visible Instances of an Application TCook Excel Programming 4 October 9th 05 05:11 AM
Application.visible help Glen Mettler[_4_] Excel Programming 0 February 16th 05 10:04 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"