Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel with an embedded Word Doc | New Users to Excel | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Embedded Word document | Excel Discussion (Misc queries) | |||
Embedded Excel Spreadsheet in MS Word Corrupted | Excel Worksheet Functions | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) |