LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change label of an embedded-object icon hmm Excel Discussion (Misc queries) 3 April 4th 23 11:34 AM
Icon Sets - Display icon in one cell depending upon value in anoth Nolene Excel Worksheet Functions 2 February 26th 10 05:43 AM
Help with toggling display Tom Excel Discussion (Misc queries) 3 June 28th 09 12:55 PM
Embed object icon missing text and image CWilminko Excel Discussion (Misc queries) 0 March 5th 09 08:08 PM
Change label text on an inserted object displayed as icon Valdus Excel Discussion (Misc queries) 1 September 19th 08 07:17 AM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"