Linking to Objects in Worksheet

[tt1]

Is it possible to link to an object on another worksheet in the same workbook. I can't seem to do that. The workbooks is N:\Claims highlights\NY Highlights Templates.xls, the worksheet is Charts and the named region on the worksheet is test. Any help would be greatly appreciated.

[Ed Ferrero]

Hi tt1,

> Is it possible to link to an object on another worksheet in the same
> workbook. I can't seem to do that. The workbooks is N:\Claims
> highlights\NY Highlights Templates.xls, the worksheet is Charts and the
> named region on the worksheet is test. Any help would be greatly
> appreciated.

Not sure what you want to do, but here are three things to try;

1) Use formulas to bring the values across.
=Sheet1!A1 will show the value of cell A1 in Sheet1

2) Use hyperlinks to link to data in the workbook.
Use the menu item Insert - Hyperlink
Click on Place in This Document on the left column
Select the defined name to link to from the list shown

3) Use the camera tool to create a picture of a worksheet
range that updates in real time.
Right-click a toolbar and choose Customize from the menu
Click on the Commands Tab, choose the Tools category,
scroll down in the commands list until you see the Camera
button (it is a fair way down). Drag the Camera button
onto one of your existing toolbars.

Now select a range and click the Camera button, then click
somewhere on a worksheet - the range is copied as a linked
picture. Change cell contents in the original range - the
picture changes too.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

[DerekB]

Coincidence or not? The only references to "Camera tool" are in replies to
two different questions on the same day.

Why is this tool so carefully hidden? Looking into the Knowledge Base, I get
the impression that it was supposed to have disappeared sometime around Excel
95. I first became aware of it when using Excel 97 and by then no trace of it
could be found in the Help texts. I suddenly had a need for it recently and
it took some effort to find it again. The semi-hidden "Copy Picture" function
(Shift Edit is needed to locate it) is not as good as it is a static copy and
is not updated when the source changes.

In an attempt to find out more about the camera tool, I tried to see the
equivalent Visual Basic commands by using Record Macro but the secret is so
well protected that it doesn't work when Record Macro is running and so I
failed to learn anything.

There are situations where this is the perfect way to summarise data in a
large multi-worksheet file. It's a pity it cannot be brought back into the
range of easily accessible tools.

--
DerekB

[Norman Jones]

Hi Derek,

> The semi-hidden "Copy Picture" function
> (Shift Edit is needed to locate it) is not as good as it is a static copy
> and
> is not updated when the source changes.

Try:

Shift - Edit | Paste Picture Link


---
Regards,
Norman


"DerekB" <[email protected]> wrote in message
news:[email protected]...
> Coincidence or not? The only references to "Camera tool" are in replies to
> two different questions on the same day.
>
> Why is this tool so carefully hidden? Looking into the Knowledge Base, I
> get
> the impression that it was supposed to have disappeared sometime around
> Excel
> 95. I first became aware of it when using Excel 97 and by then no trace of
> it
> could be found in the Help texts. I suddenly had a need for it recently
> and
> it took some effort to find it again. The semi-hidden "Copy Picture"
> function
> (Shift Edit is needed to locate it) is not as good as it is a static copy
> and
> is not updated when the source changes.
>
> In an attempt to find out more about the camera tool, I tried to see the
> equivalent Visual Basic commands by using Record Macro but the secret is
> so
> well protected that it doesn't work when Record Macro is running and so I
> failed to learn anything.
>
> There are situations where this is the perfect way to summarise data in a
> large multi-worksheet file. It's a pity it cannot be brought back into the
> range of easily accessible tools.
>
> --
> DerekB
>

[Norman Jones]

Hi Derek,

Additionally, you can add a Camera icon to a toolbar you will find it via:

View | Toolbars | Customise | Commands | Tools


---
Regards,
Norman