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:
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
Bookmarks