I frequently use the camera tool to create pictures linked to cell ranges.
For example to be able to have different column widths beneath each other on one sheet.
They have one major drawback however: they can slowdown VBA performance (when updating cells) enormously (update time may go up from .2 secs to as much as 8 seconds for the same code).
Each camera tool object uses a defined name, defined such as:
Then I use these two tiny subs to turn the picture updating on and off:
ThisWorkbook.Names(“PicsOn”).RefersTo = “0”
ThisWorkbook.Names(“PicsOn”).RefersTo = “1”
Works a treat.
Jan Karel Pieterse