Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
The RangeFromPoint method cannot be used on a chartsheet to get the Shape below given coordinates. For example, the following code with return the name of the rectangle, if you draw a rectangle at the top-left corner of a worksheet, but it will generate a bug for a chart sheet: Public Sub MyName() Dim ObjShape As Object Set ObjShape = ActiveWindow.RangeFromPoint(x:=200, y:=200) If Not ObjShape Is Nothing Then MsgBox ObjShape.Name End If End Sub Is there something equivalent for chartsheets? If not, it would be great that RangeFromPoint is available on Chartsheets. Regards, Mr T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 and chart as chartsheet | Charts and Charting in Excel | |||
Is it possible to hyperlink from a worksheet to a chartsheet? | Charts and Charting in Excel | |||
1 ChartSheet, 10 worksheets | Charts and Charting in Excel | |||
RangeFromPoint Only Finds ShapesAt 0, 0 coordinates | Excel Programming | |||
Does RangeFromPoint Method return ranges? | Excel Programming |