Protect User from edit Control Toolbox (Design Mode)

[Chrilee]

Hi,

How can I protect user from able to switch to Control Toolbox (Design Mode)?
Is there any way to disable user to go to design mode except the person who
design to form?

 

[Jacob Skaria]

Dear Chrilee

You can password protect the VBE. In VBE interface...

Tools|VBA Project Properties|Protection Tab
Check lock and password protect

If this post helps click Yes

 

[Chrilee]

Hi Jacob,

Example, I have created button and text box in the Excel sheet and not the
VBA form. Using the Control Toolbox. But I do not want user to be able to
switch to the design mode. How can I prevent this?

Tools|VBA Project Properties|Protection Tab
is not what I'm looking for. But is also something new to me. Thanks you.