[Jimbo213]

Love the camera object but I don't having to set the fill and line to
transparent every time I drop an object.

How do I set the following two default values so I don't have to continually
update the camera pictures

Format Picture Colors and Lines Fill Color == Transparent
Format Picture Colors and Lines Line Color == NoLine

I can't find a Tools Option for this.

thanks, Jimbo213

[Jon Peltier]

Use a different approach. Copy the range, click somewhere, hold Shift while
click on the Edit menu, and choose Paste Picture Link. The effect is a
linked picture just like the Camera produces, but it's transparent without a
border.

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


"Jimbo213" wrote in message
...

Love the camera object but I don't having to set the fill and line to
transparent every time I drop an object.

How do I set the following two default values so I don't have to
continually
update the camera pictures

Format Picture Colors and Lines Fill Color == Transparent
Format Picture Colors and Lines Line Color == NoLine

I can't find a Tools Option for this.

thanks, Jimbo213

[Jimbo213]

Works just fine - thanks
Jimbo213


"Jon Peltier" wrote:

Use a different approach. Copy the range, click somewhere, hold Shift while
click on the Edit menu, and choose Paste Picture Link. The effect is a
linked picture just like the Camera produces, but it's transparent without a
border.

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


"Jimbo213" wrote in message
...

Love the camera object but I don't having to set the fill and line to
transparent every time I drop an object.

How do I set the following two default values so I don't have to
continually
update the camera pictures

Format Picture Colors and Lines Fill Color == Transparent
Format Picture Colors and Lines Line Color == NoLine

I can't find a Tools Option for this.

thanks, Jimbo213