Is that because the activewindow is the VBE?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rob van Gelder" wrote in message
...
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?