ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Toggling Display as Icon for OLE Object (https://www.excelbanter.com/excel-programming/334441-toggling-display-icon-ole-object.html)

[email protected]

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?



All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com