Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been trying to add a hyperlink to a shape using the following in
Excel 2002: ActiveSheet.Shapes("Object 1").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:= _ "http://www.cas.org/" This code was generated by recording a macro. The hyperlink was successfully added during the recording, and works just fine. However, when I run this recorded macro, I get a: Run-time error '5': Invalid procedure call or argument After a little experimentation, I found I can add a Range object as an Anchor, but not a Shape object as the documentation indicates that I should. Does anyone have a solution to this problem? Thanks, Rand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Adding a tip when the mouse is hovered over a shape in Excel.... | Excel Programming | |||
Error when using VBA to change hyperlink on a shape | Excel Programming | |||
Programmatically adding buttons to a worksheet (Shape Object) | Excel Programming | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming |