|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 18th 07, 02:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Change label of an embedded-object icon
I inserted a Microsoft Word file as an object on a worksheet, displayed as an
icon. The icon is labelled "Microsoft Word Document." I would like to give it a more descriptive name, but could not figure out how. Selecting the icon shows in the formula bar: =EMBED("Word.Document.8",""). Trying to change the text between either pair of quotation marks gave me the error message "The text you entered is not a valid reference or defined name." How do I change the label of the embedded-object icon? 
|
| Ads |
|
#2
October 18th 07, 03:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change label of an embedded-object icon
hmm,
When you insert the object, select the "Create from file" tab, then check both "Link to file" and "Display as icon" . Then you can use the "Change Icon" button, and edit the caption. HTH, Bernie MS Excel MVP "hmm" > wrote in message ... >I inserted a Microsoft Word file as an object on a worksheet, displayed as an > icon. The icon is labelled "Microsoft Word Document." I would like to give > it a more descriptive name, but could not figure out how. Selecting the icon > shows in the formula bar: =EMBED("Word.Document.8",""). Trying to change the > text between either pair of quotation marks gave me the error message "The > text you entered is not a valid reference or defined name." > > How do I change the label of the embedded-object icon?
|
|
#3
October 18th 07, 04:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change label of an embedded-object icon
Thanks Bernie.
"Bernie Deitrick" wrote: > hmm, > > When you insert the object, select the "Create from file" tab, then check both "Link to file" and > "Display as icon" . Then you can use the "Change Icon" button, and edit the caption. > > HTH, > Bernie > MS Excel MVP > > > "hmm" > wrote in message > ... > >I inserted a Microsoft Word file as an object on a worksheet, displayed as an > > icon. The icon is labelled "Microsoft Word Document." I would like to give > > it a more descriptive name, but could not figure out how. Selecting the icon > > shows in the formula bar: =EMBED("Word.Document.8",""). Trying to change the > > text between either pair of quotation marks gave me the error message "The > > text you entered is not a valid reference or defined name." > > > > How do I change the label of the embedded-object icon? > > >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| embedded pdf object | [email protected] | Excel Worksheet Functions | 1 | October 8th 07 04:32 PM |
| Linking to Embedded object | CB | Excel Discussion (Misc queries) | 0 | May 1st 07 07:36 PM |
| Link To Embedded Object | Brainfire | Excel Discussion (Misc queries) | 0 | June 21st 06 02:40 PM |
| Embedded Object Flickering | dlerh | Excel Discussion (Misc queries) | 0 | May 2nd 06 07:56 PM |
| size of embedded object | Amy Wang | Excel Discussion (Misc queries) | 0 | December 9th 05 10:15 PM |
Linear Mode
