I have a textbox (VBA shape type 17) embedded in a chart embedded in a worksheet that is protected:
Sheet11.ChartObjects(1).Chart.Shapes(1)
I want to assign calculated text to the textbox using VBA.
With the worksheet protected, I can successfully set the text in Excel 2016 using this (and...