Prevent VBE from opening

[Whisperer14]

I am aware that password *******s can render the password protection of VBA code ineffective.

The only way that I can think of getting around the problem is to prevent the VBE opening from either the Alt+F11 or the 'View Code' options.

Any idea would be most welcome, even if it is a 'No, it cannot be done' in which case I shall have to learn VB or Delphi .

 

[Cbrine]

There is no foolproof way to do it. This code will disable most options, but the right click on the worksheets tabs allows you to still enter the VBE. Of course the user has to press the enable macro's option to let the code run.


Application.CommandBars("Visual BaSIC").Enabled = False
Application.CommandBars.DisableCustomize = True
Application.OnKey "%{F11}", ""

 

[Whisperer14]

Thanks Cbrine, I have used just the last of the 3 options, setting Fll to "", how do I restore it to open the VBE please?

 

[Cbrine]

Well, for the part you need to send a cheque.

Just kidding.

Application.OnKey "%{F11}"

Cal

 

[NdNoviceHlp]

This link may be of some use. Dave
http://www.mrexcel.com/board2/viewtopic.php?t=53195&highlight=

 

[Whisperer14]

Dave,

What a nightmare situation!

Thank you for the link, your solution was very interesting but it begs a question. If the master file is closed then the safeguards are negated, is there a way of ensuring that it is not visible in the Taskbar and automatically closed when the opened program is closed?
TIA
Gordon

 

[NdNoviceHlp]

At the risk of being censored again, I will provide some suggestions and not evil code. Assuming that the "master" file is your actual program that you want protected, if you make the calling program an addin on workbook closed and the "master" program not an addin on workbook open, the result is that only the "master" program will be in the taskbar and you will not have access to the VBA editor. Sorry I can't be more specific. Hope this helps. Dave