Using Application.caller with Shapes

Hi all,

I have multiple same shapes in the same column, wih each of them 6 rows apart.

I would like to write one single macro and assign to each shapes, so that when I click on any of the shape, the 6 rows under the shape will be hidden.
For example, my first shape is embedded on L18. When I click on it, I want L19:L24 to be hidden.

Below are the codes that I tried, but keep showing object require error

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any assistance is very much appreciated.

Thank you!

Hi,

check first what returns Caller property and without notice which line runs the error and its exact message
neither a workbook attached …

Hi Roy,

Thank you very much for your suggestion!
It works as I intended to.

Thanks!