G
Guest
I have a sheet with an embedded Word doc in it. When you double-click the
Word icon in the sheet, the doc opens. What I'd really like to do, though, is
cover up the icon with a more user-friendly AutoShape that has instructions
on it. (You know, "Click here to go to...") I've tried attaching a simple
macro to the AutoShape to open the document hidden underneath. (The Word icon
is "Object 10"):
Sub Activate_Object_Macro()
ActiveSheet.Shapes("Object 10").Activate
End Sub
But I get an error message saying the object doesn't support this method.
Then I tried this:
Sub Activate_Object_Macro()
Application.ActivateMicrosoftApp xlMicrosoftWord
ActiveSheet.Shapes("Object 10").Select
End Sub
But all that that is, well, select the icon--it doesn't open the doc. What
am I missing?
Of course, if I could just reformat the icon itself to look like what I
want, this wouldn't be necessary. Is that possible, either?
Please help--I'm supposed to show this thing at a meeting this afternoon!
Word icon in the sheet, the doc opens. What I'd really like to do, though, is
cover up the icon with a more user-friendly AutoShape that has instructions
on it. (You know, "Click here to go to...") I've tried attaching a simple
macro to the AutoShape to open the document hidden underneath. (The Word icon
is "Object 10"):
Sub Activate_Object_Macro()
ActiveSheet.Shapes("Object 10").Activate
End Sub
But I get an error message saying the object doesn't support this method.
Then I tried this:
Sub Activate_Object_Macro()
Application.ActivateMicrosoftApp xlMicrosoftWord
ActiveSheet.Shapes("Object 10").Select
End Sub
But all that that is, well, select the icon--it doesn't open the doc. What
am I missing?
Of course, if I could just reformat the icon itself to look like what I
want, this wouldn't be necessary. Is that possible, either?
Please help--I'm supposed to show this thing at a meeting this afternoon!