Windows 11 Update has affected controls on UserForm

[Oseitutuakrasi]

I just updated my Windows 11, and upon opening my Excel workbooks I realized that all controls on my userforms have shifted. I have 100s of controls on different userforms
and it will take me weeks to readjust them all. My worry is that this could happen again in the future. Can anybody help me find a solution to save me hours of rework?
My screen resolution has not changed!

Thanks
Samuel

 

[Micron]

Check your Windows scale settings. It may have been altered (e.g. you had it at 125% but now it's back to 100%).
Go to Settings>Display>Scale and Layout

 

[Oseitutuakrasi]

Check your Windows scale settings. It may have been altered (e.g. you had it at 125% but now it's back to 100%).
Go to Settings>Display>Scale and Layout

Thanks Micron,
That was the culprit. Yes, back to 125% now and all good.

Regards,
Samuel

 

[Oseitutuakrasi]

Check your Windows scale settings. It may have been altered (e.g. you had it at 125% but now it's back to 100%).
Go to Settings>Display>Scale and Layout

It is me again Micron. Your solution has opened my eyes to some issue. Does it mean that if I give my workbook to someone to run, they might face the same issue if their display resolution/scale is different from mine (i.e. my computer where the workbook was created)? If that is the case, do you know of any VBA code (or probably Windows API) that can be used to adjust the user's settings to match mine and then reset it back after closing the workbook. Sorry for any inconvenience.

Regards,
Samuel

 

[Micron]

My opinion is that adjusting anyone else's pc settings to match your designer settings is verboten - assuming you even can. Not only would you need to worry about ensuring you put them back to what they were (which means you first need to know what they are), there is no way you can stop them from switching apps, only for them to discover that things looked OK in Excel, but are messed up in every other app they switch to. When designing, you have to design for the norm, whatever that may be. I imagine it is possible with API's but you might also have to code for 32 bit vs 64 bit

When I was still working, 95-ish percent of people using my db's were using "normal" resolution of (IIRC) 1024x768. There were some hold-outs that were stuck in a rut so to speak, and still using 800x600 from the time of the dinosaurs. So they had a lot of scrolling to do. I'd say that if you designed with 125% scale and most other users are using 100% scale then you made a mistake. I suppose you could have a disclaimer like "this file is best used at 125% scale in Windows Setting" but be prepared for backlash. Many will have no idea what that means, and don't want to go there. The biggest downfall, as I've suggested, is that the settings will apply to any application they look at, and that will include Outlook, Access, any web browser page, Excel, Word, etc. etc. I confess I cannot say for sure that I'm right about that but you could verify by seeing how other apps appear to you compared to before the update. Or you can make screen captures of the same window with different scale settings and compare those captures.

 

[Oseitutuakrasi]

My opinion is that adjusting anyone else's pc settings to match your designer settings is verboten - assuming you even can. Not only would you need to worry about ensuring you put them back to what they were (which means you first need to know what they are), there is no way you can stop them from switching apps, only for them to discover that things looked OK in Excel, but are messed up in every other app they switch to. When designing, you have to design for the norm, whatever that may be. I imagine it is possible with API's but you might also have to code for 32 bit vs 64 bit

When I was still working, 95-ish percent of people using my db's were using "normal" resolution of (IIRC) 1024x768. There were some hold-outs that were stuck in a rut so to speak, and still using 800x600 from the time of the dinosaurs. So they had a lot of scrolling to do. I'd say that if you designed with 125% scale and most other users are using 100% scale then you made a mistake. I suppose you could have a disclaimer like "this file is best used at 125% scale in Windows Setting" but be prepared for backlash. Many will have no idea what that means, and don't want to go there. The biggest downfall, as I've suggested, is that the settings will apply to any application they look at, and that will include Outlook, Access, any web browser page, Excel, Word, etc. etc. I confess I cannot say for sure that I'm right about that but you could verify by seeing how other apps appear to you compared to before the update. Or you can make screen captures of the same window with different scale settings and compare those captures.

Many thanks for this Micron. My Windows settings recommend 1920 x 1080 resolution and a scale of 125%. I think I will stick with this and tell users this is my "System Requirement" just to cover my backside. I guess I cannot please everyone. Many thanks for the insight.

Regards.

 

[Micron]

Glad I could help. If you have a solution it would be good if you mark your thread as solved.