Can anyone tell me how to retrieve a screen's pixels-per-point ratio in VBA? I've tried this:
[vba]MsgBox CDbl(1) / CDbl(ActiveWindow.PointsToScreenPixelsX(1))
[/vba]
But I must be misinterpreting the usage of PointsToScreenPixels because the above gives a negative number. And moreover 1/PtsToPix(1) <> 100/PtsToPix(100).
Plus any reference to ActiveWindow breaks when not actually run from the workbook (i.e., debugging from the code-window doesn't work).