View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Using ActiveWindow.PointsToScreenPixelsY

I get the same result when running from VB.
But if I create a macro and run that macro from an Excel button, then it
works.

Doesn't seem to like runnig from VB

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pancho" wrote in message
...
I am trying to use the ActiveWindow.PointsToScreenPixelsY
and all I have is a zero, as response.
I tryed:
hMap=ActiveWindow.PointsToScreenPixelsY(1)
hMap=ActiveWindow.PointsToScreenPixelsY(10)
hMap=ActiveWindow.PointsToScreenPixelsY(100)
hMap=ActiveWindow.PointsToScreenPixelsY(1000)

hMap is a Long variable, in all cases I obtained a zero.
I am using it on Excel 2000, with Windows 2000.

Any suggestions?