On my form I was using the build in form protection which seemed fine. However it does weird things with checkboxes.



On searching it looks like you should not use this for Content Controls and instead create a group and lock it this way.

This is fine but then my conditional VBA shading will not work because the content is locked for editing.

I have tried:

CC.LockContentControl = False
CC.LockContents = False

However these do not work.

So what am I meant to do to allow my VBA to do some editing to Content Controls without risking the user editing the form and without checkboxes going strange?

Thanks a lot