A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Change label of an embedded-object icon



 
 
Thread Tools Display Modes
  #1  
Old October 18th 07, 02:36 PM posted to microsoft.public.excel.misc
hmm
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?
Ads
  #2  
Old October 18th 07, 03:50 PM posted to microsoft.public.excel.misc
Bernie Deitrick
external usenet poster
 
Posts: 5,444
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?



  #3  
Old October 18th 07, 04:36 PM posted to microsoft.public.excel.misc
hmm
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?

>
>
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 05:50 PM.


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