Excel Optimise For Best Appearance Option Breaks User Forms

[petrovich60]

I am having the following problem: my client updated excel version and all user forms appear to be broken.

There is a special default setting "Optimize for best appearance"(When using multiple displays) in newer excel versions that causes the problem. When I switch to "Optimize for compatibility" option, the problem is gone.

Question: did someone figure out how to change this setting programmatically(in VBA code)?

I tried to record the macro and change the settings but no luck. The resulting program is empty.

Please share.

[TMS]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional.)


Cross posted at: https://stackoverflow.com/questions/...aks-user-forms