Protect vba code

[rhombus4]

Is it possible to hide/protect vba code but allow access to a user form properties.

I know you can password protect the user form properties which doesn't allow access to the user form or code but can you protect just the VBA code

 

[Kyle123]

No, you cannot. Out of curiosity, why do you want to do this?

 

[rhombus4]

No, you cannot. Out of curiosity, why do you want to do this?

Somebody wanted ability to edit/format questions and maybe other areas of the user form. I spent a lot of time doing the code and didn't want to have access to it.

ps I know you can do it via initialisation process changing questions etc

 

[elizabethlee]

Go to Tools > VBEProject Properties > Protection page tab > Check lock project from viewing.

 

[Fluff]

@elizabethlee
That won't allow users to edit the form.

@rhombus4
Why not put the questions on a sheet & then pull them onto the form with the initialise event.