Question on Locking vs Protection

[Trader174]

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

[gmayor]

Locking a content control prevents it from being deleted. It doesn't lock the form. What you need is to add editors to the content controls and then lock the form as readonly. Then users will only be able to access the content controls.

An easy way to do this is to use the edit all controls option of
Insert Content Control Add-In