Refresh Image or Plot with Button/Macro

Python in Excel How-To
1

Hi,

Is there a method to have the image/plot created by a script only refresh when prompted by a Button/Macro instead of refreshing every time a separate cell is updated?

Thanks

2

In Python in Excel you can use Manual or Partial calculation mode to gain more control over how cells are refreshed.

See the “Recalculation” section here for more details.

Controlling calculation and creating Python cells with VBA is also possible.

I made an example video some time ago which shows how to create a Python cell from VBA. It isn’t directly related to your ask, but may provide some ideas for you to work from.