Camera Tool Unwanted Copying

[Justinian]

I am creating a dashboard that requires the camera tool. The reason is because I have custom formatting (red if negative number and green if positive) and I cannot use custom formatting on shapes, which is what my dashboard consists of. Each section of my dashboard is a square and one each square, I have a donut chart showing work order created vs completed. In the middle of that chart, I want to display the difference between created and completed but I cannot use a shape with custom formatting so I am using the camera tool. The problem is when I open the workbook or make changes, sometimes the camera image copies on top of itself.

Any idea why this happens or how I can stop it?

 

[James006]

Hi,

Back to the origin of your question ... it seems to me an Event macro could format/color your shape ...
Have you considered this possibility ?

 

[Justinian]

I have not because I am not that adept with VBA.

 

[James006]

If you feel like exploring a little bit this area :

VBA Coding For Shapes (The Complete Guide)

Learn all about automating the creation of shape objects and how to make them look just the way you want with VBA macro code.

www.thespreadsheetguru.com

 

[Justinian]

Thank you.

 

[James006]

You are welcome

If you need some specific assistance regarding your particular situation, do not hesitate to post back

 

[Justinian]

Just wondering if you know why the camera tool reacts that way.

 

[James006]

The Camera tool was designed originally to provide a replicate of a range ...

but also to remain constantly dynamic and updated, should the source range be modified ...

 

[Justinian]

I do not change the source range but when I make changes, sometimes the camera image replicates itself, which is odd.

 

[James006]

Do you use F9 to recalculate formulas ?

Do you have an Event macro for changes ?

Do you have a cell with something like a date, a time ?