Hi there:

I wrote a macro to set the width of legend of a dynamic chart. It works well on an unprotected worksheet.

Once the worksheet is protected, I get a runtime error.

How to solve the problem while the properties of legend in a dynamic chart is set by macro on a protected worksheet.

The excel file is attached.

Thanks!