Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Change label of an embedded-object icon

To change the label of an embedded-object icon in Microsoft Excel, follow these steps:
  1. Double-click on the icon to open the embedded object.
  2. In the embedded object, click on the File menu and select Properties.
  3. In the Properties dialog box, you will see a field labeled "Title." This is where you can change the label of the embedded-object icon.
  4. Type in the new label you want to use for the icon in the Title field.
  5. Click OK to save the changes and close the Properties dialog box.
  6. Close the embedded object and return to the Excel worksheet. You should now see the new label displayed on the icon.

Note that changing the label of the embedded-object icon does not change the name or contents of the embedded object itself. It only changes the label that is displayed on the icon in the Excel worksheet.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,441
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default 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?




Reply
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
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


All times are GMT +1. The time now is 02:59 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"