BillManville
New Member
- Joined
- Apr 4, 2022
- Messages
- 3
- Office Version
- 365
- 2010
- Platform
- Windows
I recently obtained a new laptop which has Windows 11.
I maintain an application for a client which runs in Excel 2010 [he has his reasons] with lots of VBA code.
It generates charts and copies a picture of the latest chart into a userform
In previous versions of Windows the sizing of the chart worked fine
Windows 11 has a facility to change the scaling of the display and that screws up my sizing.
For some reason a scaling of 125% gives the desired result. Scaling of 100% results in the chart being too big and scaling of 150% makes it too small for the space available on the user form.
I figure there must be a way to determine the scaling being used and to adjust the size of the chart accordingly
But I can't find a Windows API that will give me the scaling info
Has anyone here found it?
[Hi to any old friends who are hanging out here]
Bill Manville
Ex MVP
I maintain an application for a client which runs in Excel 2010 [he has his reasons] with lots of VBA code.
It generates charts and copies a picture of the latest chart into a userform
In previous versions of Windows the sizing of the chart worked fine
Windows 11 has a facility to change the scaling of the display and that screws up my sizing.
For some reason a scaling of 125% gives the desired result. Scaling of 100% results in the chart being too big and scaling of 150% makes it too small for the space available on the user form.
I figure there must be a way to determine the scaling being used and to adjust the size of the chart accordingly
But I can't find a Windows API that will give me the scaling info
Has anyone here found it?
[Hi to any old friends who are hanging out here]
Bill Manville
Ex MVP