VBA to protect Active X controls form editing, while allowing editing of charts?

  • I know that both charts & Active X controls are considered objects by Excel. Currently the worksheet is protected & editing objects are allowed. I have googled, & have not found anything regarding this possibility. I am trying lock down the active X controls, but allow editing of charts. I don't think it is possible, but I thought the experts here may have an answer.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!