Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggling Display as Icon for OLE Object
I have a Word OLE Object inserted in my an Excel worksheet. I would
like the user to have option of toggling between an "active view" (the view in which I can see the normal Word content of the OLE and a double click will allow me to make edits directly into the OLE without having to open Word in a seperate window) and the "icon view" (the view in which you can *not* see the normal Word content and a double click will open Word in a seperate window. Manually, I can toggle between these two views. This is done by right clicking the object, Document Object Convert Convert to: Microsoft Word Document Display as icon. If the Display as icon checkbox is checked, I can now see the object with an "icon view". If the Display as icon checkbox is unchecked, I can now see the object with an "active view". This is what I want, but it has to be done manually. Programmically, I do not know how to do this (switch between the two views). I have tried recording a macro but it does not pick up any code for my checking and unchecking of the Display as icon checkbox. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change label of an embedded-object icon | Excel Discussion (Misc queries) | |||
Icon Sets - Display icon in one cell depending upon value in anoth | Excel Worksheet Functions | |||
Help with toggling display | Excel Discussion (Misc queries) | |||
Embed object icon missing text and image | Excel Discussion (Misc queries) | |||
Change label text on an inserted object displayed as icon | Excel Discussion (Misc queries) |