Optimise For Best Appearance Option Breaks User Forms
I am having the following problem: my client updated Excel version and all user forms appear to be broken. (Described here: Excel UserForm displays at the wrong size)
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.
I did not manage to find a workaround. Apparently when the "optimise for best appearance" option is active and multiple monitors are connected to a device, excel cannot properly build buttons, objects etc. Telling each user not to use multiple monitors or to switch this option manually off is not an option.
I am changing right now the application in the way that I do not use any objects. It sucks but there is no other way.
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- convert a C# datetime object into Excel date format
- Get values from available column in a row to the first column of the same row
- VBA - Worksheet.activate not working
- Transform datatable from column-based to row-based
- Check for consecutive characters in an excel cell
- Add text to first available cell in range with non-contiguous cells
- Data Entry Transfer to Multiples Tables to Specific Sheets
- ExcelScript fails on webapp, succeeds on desktop
- Is there is Limition of using opencsv API or Apache Poi Api?
- How can I merge one excel datasheet with a master excel sheet with only some columns matching?
- How to access textBox placed on sheet in VBA module?
- Looking to create a copy of a document and copy data from Excel (words and tables) into it at bookmarks
- Only loop selected rows in Excel VBA
- How to pass multiple Excel sheets as data table when using ExcelDataReader?
- Combine most recent 5 records into one cell in Excel
- AutoFilter returning to 1st Range when trying to apply filter to different Range
- Importing Excel-tables in R
- Using Python, how to update an excel sheet on Azure Blob Storage while maintaining existing data in the sheet?
- Reorder sheet names in custom order
- Dynamic array using xlwings causing formula to be wrapped with {}
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How to split a string into a 2-dimensional array in vba?
- Filter Range C3:G3 And paste to other cells
- How to solve Excel VBA: Compile error in hidden module
- Conditional Format Cells with Special Characters including Accented Letters, Numbers, and Punctuation