Change label of an embedded-object icon

H

hmm

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?
 
B

Bernie Deitrick

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
 
H

hmm

Thanks Bernie.

Bernie Deitrick said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
Embed the same Excel multiple times 0
Inserting an audio file and displaying note or label, not the file name 0
Unable to open embedded word document from Excel 0
embedded documents - label text reverts to a default 0
Embed object icon missing text and image 0
Change label text on an inserted object displayed as icon 1
How do I link to an embedded object 1

Top