Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default can't display link as icon

I have a list of items in one column and want to link to the description of
each in the next column. Excel displays the lengthy description in the link
cell, and I just want a space-saving icon so the user can display all the
detail only if desired. The instruction in Help sound exactly like what I
want, and say:

"You can display a linked object or embedded object in a workbook exactly as
it appears in the source program or as an icon. If the workbook will be
viewed online, and you don't intend to print the workbook, you can display
the object as an icon. This minimizes the amount of display space it
occupies. Viewers who want to display the information can double-click the
icon.
1. Click the icon for the linked or embedded object you want to display.
2. On the Edit menu, point to object type Object (for example, Document
Object), and then click Convert.
3. To display the content of the object, clear the Display as icon check
box.
To display an icon of the object, select the Display as icon check box. To
change the default icon image or label, click Change Icon, and click the icon
you want from the Icon list, or type a label in the Caption box.
"

BUT I can't even do step 1 because there is no icon to begin with. When I
open the edit menu from the cell, the "Link" and "Object" options are both
greyed out.
Any ideas how to make this work?

many thanks.
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
Paste Special\Unformatted Text\Display as Icon sam Excel Discussion (Misc queries) 0 January 8th 08 03:46 PM
Display Database Icon in the Formula Tab Max Excel Discussion (Misc queries) 0 June 13th 07 10:01 AM
Link cell between WS w/o dest display 0-jan if no entry at source Jack Miller Excel Worksheet Functions 1 June 5th 06 09:00 AM
Display the complete URL instead of a link Susan Excel Discussion (Misc queries) 2 November 23rd 05 03:30 PM
display a picture in excel as an icon Jeff Excel Discussion (Misc queries) 1 February 12th 05 02:38 AM


All times are GMT +1. The time now is 09:20 AM.

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

About Us

"It's about Microsoft Excel"