Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Change label text on an inserted object displayed as icon

My problem is the text that is displayed with the icon when I "Insert
Object Create from File Display as icon". It shows the absolute path to
where the file was located on my hard drive when inserting the object, rather
than just showing the file name. Also there is not enough space to show the
complete path if it is long.

Example of when this disturbs me:
If I for example want to insert two word documents displayed as icons in
Excel, which both are placed in the same sub-sub-sub-...-folders to the root
then there will be no visual difference between the icons. If I then in a
text cell in Excel refer to the two different file the reader of the document
have to open both files to find out which one I am talking about.

What I want to know:
How can I get only the file name to be displayed with the icon?
OR
How can I manually change the text to anything I want?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Change label text on an inserted object displayed as icon

Sometimes I think there is a god with a strange sense of humour...

This has bothered me every now and then for years, I have been searching
everywhere for the solution. And then just a few minutes after I take the
step to post the question I find it out my-self...

If someone else have the same problem here is the solution:
When inserting the object, after browsing for the file and choosing the
optioon "Display as icon", press the "Change icon" button. In the bottom of
the dialog that appears you can modify the Caption....

However, I still don't know if this is possible after the object has been
inserted, but that's a very small problem that I don't care about right now!

"Valdus" wrote:

My problem is the text that is displayed with the icon when I "Insert
Object Create from File Display as icon". It shows the absolute path to
where the file was located on my hard drive when inserting the object, rather
than just showing the file name. Also there is not enough space to show the
complete path if it is long.

Example of when this disturbs me:
If I for example want to insert two word documents displayed as icons in
Excel, which both are placed in the same sub-sub-sub-...-folders to the root
then there will be no visual difference between the icons. If I then in a
text cell in Excel refer to the two different file the reader of the document
have to open both files to find out which one I am talking about.

What I want to know:
How can I get only the file name to be displayed with the icon?
OR
How can I manually change the text to anything I want?

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
Change label of an embedded-object icon hmm Excel Discussion (Misc queries) 3 April 4th 23 11:34 AM
How can I remove a calendar object I inserted in a spreadsheet? Buddy M Excel Discussion (Misc queries) 4 October 27th 08 05:25 PM
Icon for inserted file object doesn't collapse away when closeoutline group Paul Excel Discussion (Misc queries) 2 April 1st 08 10:46 PM
how do i copy and inserted drawing object in a cell to multiple ce BROCK8292 Excel Discussion (Misc queries) 1 February 20th 07 09:11 PM
How change dimensions of data label text box in pie chart? Gouden Willem Charts and Charting in Excel 3 March 7th 06 12:11 PM


All times are GMT +1. The time now is 04:43 PM.

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"