Automating the Excel camera function
 

Hi All,

A colleague of mine has just shown me the Excel camera function, which looks
to be a very useful tool, but he's found a problem with it.

On a spreadsheet which contains a number of these linked images, if the
underlying cells are updated, the process of regenerating the images slows
down the overall recalculation of the spreadsheet. Is there a way to
automate the creation of these images so that they only appear after the
macro doing the spreadsheet recalculation has finished. Alternatively can
the refresh of the images be enabled and disabled from a macro?

Thanks in advance