Single excel instance + VBE disabling
 

Hi,

I have a few difficult questions which i'm hoping that
someone may be able to answer.

I have an excel spreadsheet that i want to be opened in a
separate instance of excel (We are using Excel 97 but will
be going to XP in a few months). For this instance of
Excel I want to make it so that user cannot open the VB
Editor. - is this possible?

Thank you kindly,
Steven

Single excel instance + VBE disabling
 

Steven,

Protecting the VBA project disables the user's
ability to view the code, he may open the window
but cant do anything.

Note you may need to add some error handling to
recover from stateloss.

If it's a performance issue and you want to make
sure the user closes the VBE before running it use:

Application.VBE.MainWindow.Visible=False




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Steven Revell" wrote:

Hi,

I have a few difficult questions which i'm hoping that
someone may be able to answer.

I have an excel spreadsheet that i want to be opened in a
separate instance of excel (We are using Excel 97 but will
be going to XP in a few months). For this instance of
Excel I want to make it so that user cannot open the VB
Editor. - is this possible?

Thank you kindly,
Steven