Ahhh, so it does have it's own home. Shame about the suburb though. ;-)


"Debra Dalgleish" wrote:

You can copy a range of cells, then hold the Shift key, and choose
EditPaste Picture Link.

Maybe that's what Jim remembered.

Vic Eldridge wrote:
Hi Jim,

Copy Picture produces a static image of the copied range, whereas the camera
tool produces a dynamic image of the copied range. It's like a cross between
an image and a formula. Quite powerful really.
I suspect if MS gave it a home on a prominent toolbar it would be a *lot*
more widely used.

Regards,
Vic Eldridge


"Jim Rech" wrote:


I haven't used the Camera tool in many a year but isn't it the same thing as
the Copy Picture choice you see when you hold Shift down and click the Edit
menu open? If so it might be easier.

--
Jim
"Vic Eldridge" wrote in message
...
| Hi Paul,
|
| Excel has a nifty little camera tool that often goes unnoticed due to the
| fact it doesn't appear on any of Excel's default toolbars. To use it,
you'll
| have to first add it to a toolbar, by right clicking on a toolbar and
| selecting Customize...
| On the Commands tab, select the Tools category, then in the list on the
| right, scroll down until you find the Camera tool, then drag it onto a
| toolbar of your choice.
|
|
| Regards,
| Vic Eldridge
|
|
| Right click on any toolbar then select
|
| "Paul Smith" wrote:
|
| Does anyone know of any way of producing a floating window which
contains a
| view of range from a worksheet?
|
| My requirement can be partly satisfied by using a new window, but How
can
| this be made to always be on top?
|
| Any help or references gratefully received.
|
| Paul Smith
|
|
|






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html