Hi
In my opinion it's one of the biggest mistakes MS ever brought up with the OS. To make things worse, user is encouraged to adjust the screen to his/her convenience without advise which problems this will cause.
The original setting in windows is 96 ppi and ever was. The new feature to temper with the dpi-settings brings up a hell lot of problems in excel, page setups don't fit anymore, neither printareas, ... and this continous - even vba is affected (i.e. UserForm's manually startup-positions).
There is hardly a solution, whereas in vba you can code workarounds, the excel-features you talk about aren't ajustable. Therefore do yourself a favour and adjust the dpi to 100% which equals the 96 ppi.
|