View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel Camera Object

Try this instead: Copy the range the regular way, hold Shift while selecting
the Edit menu, and choose Paste Picture Link. Same result, without a border
around the pasted picture.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"nde" wrote in message
...
Hi All,

Here is a samplke of an article I found on the net: <Excel's Camera object
is the key to traffic-light reporting. This tool has been a standard part
of
Excel for many years, but very few Excel users have ever used it.
<In a new worksheet, enter text in cell B2. If you want, add some color
and
other formatting as shown. Then select cell B2 and click on the Camera
icon.
When you do so, the border around cell B2 turns into a moving marquee, and
your mouse pointer turns into a cross.

Now click anywhere on your spreadsheet. When you do so, Excel returns the
Camera object, as shown in the illustration above. You can move this
object
anywhere on your worksheet.

Though I am not able to find the Icon, anyone knows where to find it,
looks
like a nice feature !

Thanks,
Nde