Window resizing strangeness !

[Jaafar Tribak]

Hi dear board members,

While building some VBA code to trap the resize "event" of the excel application main window, I noticed that the code failes on some machines and works on others despite working with the same excel version(2003) in both machines and both machines running the same Win Xp Ver 2002.


Taking a closer look, I noticed that the resizing of a window (any window not just that of excel) via the user interface behaves differently depending on the machine.

On machine 1 , when a window is resized, you can see the entire window resizing as you drag the window with the mouse whereas on machine 2 , you only see a shadow of the window frame and the window doesn't fully repaint until the dragging operation is completed and the mouse is released.

I had never paid attention to this oddity until now.

Why would the resizing of windows behave differently on 2 Win XP systems ! I don't know.

Does anybody know if this is documented somewhere or have any thoughts on this ?

Regards.

Edit: Although both OS are Win XP 2002, the SPs are different namely SP3 vs SP2- Could that be the reason ?

 

[Ivan F Moala]

Things like that, that are windows wide and not application specific are usually in Control panel or Display set ups.

You need to;
Control Panel
Display properties
Appearance
Effects
Select option > [Show windows contents while dragging]

 

[Jaafar Tribak]

Thanks very much Ivan.

Had never noticed this Windows feature before - and the good news is that it can easily be set programmatically via the SPI_SETDRAGFULLWINDOWS flag .

Regards.

 

[Ivan F Moala]

Thanks very much Ivan.

Had never noticed this Windows feature before - and the good news is that it can easily be set programmatically via the SPI_SETDRAGFULLWINDOWS flag .

Regards.

Yes, most system wide settings can via the user32 dll and the SPI Flags

 

[Jaafar Tribak]

Hi again Ivan,

The following is bugging me for quite a while.

I am subclassing the excel application and the code works fine on my PC at home.However, on my PC at work, the application crashes unless I first go to the VBE , click on the STOP button and then on the RESET button.- really weird stuff !

But what puzzles me the most is the fact that both PCs run with exactly the same OS version (Win XP SP2) and have the same Excel version (2003).

Have you come accross this oddity before ? Or is this a Windows setting that needs to be changed like the [Show windows contents while dragging] kind of thing mentioned in the previous post?

I hope you can shed some light on this as I often run into this problem when subclassing/hooking in VBA.

Regards.

 

[Ivan F Moala]

Hi Jaafar
I am unsure of this problem. If you find a reason why this happens please let us know.

 

[Jaafar Tribak]

Hi Ivan,

Here is an example where subclassing the excel application works on some machines but not on others unless the VBE is first reset. I am still looking to see if i can work around this annoyance as this alone spoils the whole work and make it useless.

http://www.mrexcel.com/forum/showthread.php?t=187462

Regards.