Protect User from edit Control Toolbox (Design Mode)

  • Thread starter Thread starter Chrilee
  • Start date Start date
C

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?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't find the properties in a Combo Box 2
Outlook Creating an Outlook form 2
Contol toolbox command button 2
difference between forms and control toolbox 1
Showing different properties in design/run mode - user controls 8
Control Toolbox Design Mode 2
losing command button functionality 4
Add list in Control Combo Box 3

Back
Top