Hi,

what clearly means « dynamic pictures » under Excel ?!

Elaborate « pictures and its linked formulas » …
As using formulas you may not ever need any VBA procedure.

You can activate the Macro Recorder and copy manually some 'dynamic' picture : you will get your own code base …