Single excel instance + VBE disabling

  • Thread starter Thread starter Steven Revell
  • Start date Start date
S

Steven Revell

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
 
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 >
 
Back
Top