Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link to an embedded object
I embedded a Word Doc into Excel (as an icon). I want to hyperlink to it from
another Excel worksheet, but the embedded object does not have a cell location to link to. Can I convert the embedded object to a cell or assign a cell location to the embedded object? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link to an embedded object
hi, !
I embedded a Word Doc into Excel (as an icon). I want to hyperlink to it from another Excel worksheet but the embedded object does not have a cell location to link to. Can I convert the embedded object to a cell or assign a cell location to the embedded object? op1: you can always hyperlink to the cell "below" the top-left corner of your embedded shape/object op2: you can find (vba) the .TopLeftCell.Address property of any named/looping embedded object op3: you can use xl-4 macro-functions (in named-formulae) to find the .TopLeftCell.Address of a "name" object (note: named-formula must be used on a cell in the embedded object worksheet and hyperlink to it) i.e. [Sheet1] insert / name / define... name: MyObjectCell / formula: =get.object(4,"object 1") [Sheet1!A1] =myobjectcell [other worksheet] =hyperlink("#sheet1!"&sheet1!a1,"my embedded word document icon") if you move your embedded object, change the formula-name to: =get.object(4+0*now(),"object 1") will be updated on re/calc, otherwise you will need {F2}+{Enter} on [Sheet1!A1] (among others) hth, hector. p.s. (just in case) xl-4 macro-functions may crash excel under certain circumstances (xl97/2000) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
embedded pdf object | Excel Worksheet Functions | |||
Getting an embedded object to stay put | Excel Discussion (Misc queries) | |||
Link To Embedded Object | Excel Discussion (Misc queries) | |||
Embedded Object Flickering | Excel Discussion (Misc queries) | |||
size of embedded object | Excel Discussion (Misc queries) |