I can select a shape normally with following VBA
I want to select a chart and shape inside the chart. I am not finding a line of code.
I tried the following but no success.
Actually my chart is locked and I want to keep it locked and my sheet it protected(edit object is unchecked). I inserted shape inside the chart. My target is to edit shape inside the chart in locked mode with application.caller. So I can select the shape then I ll be able to edit it.
Thanks
VBA Code:
ActiveSheet.Shapes(Application.Caller).Select
I tried the following but no success.
VBA Code:
ActiveSheet.ChartObjects(Application.Caller).Select
Actually my chart is locked and I want to keep it locked and my sheet it protected(edit object is unchecked). I inserted shape inside the chart. My target is to edit shape inside the chart in locked mode with application.caller. So I can select the shape then I ll be able to edit it.
Thanks