I have a macro enable xlsm file.
In one of the macros I want to make shape objects (pictures) on a chart sheet visible or invisible to suit the chart data.

A greatly simplified example of the macro to illustrate the problem is this:

Please Login or Register  to view this content.
I am seeing 2 different behaviours with 2 slightly different versions of excel.

Using excel version 1901 (Build 11231.20174 Click-to-Run)
The macro above will toggle visibility of images/shapes on a worksheet but NOT a chartsheet

Using excel version 1803 (Build 9126.2295 Click-to-Run)
The macro above will toggle visibility of images/shapes on BOTH a worksheet and a chartsheet

Help welcome.

Thanks

Mike