Disable Tools

[Markus]

I want to use VB to disable the control toolbox whenever
the file is opened at any time and at any place. I do not
want anyone to access the code that is currently asociated
with the file nor do i want anyone to be able to go into
design mode to alter control properties. I have a command
buttons that will allow me to view code and control
properties with password verification. I just need to keep
other users from using the control toolbox.

 

[Ron de Bruin]

Hi Markus

Protect your sheet and
Protect your VBA project in the VBA editor

This way you can go into edit mode and see the code

 

[onedaywhen]

If you decide to disable user settings (I recommend you don't), at
least ensure you restore them (i.e. allow them to use the Control
Toolbox) when they switch to another open workbook while your workbook
is open, otherwise your users will hate you and will cease using your
apps.