make VbA invisible

[Guest]

Hi:

When I try to open a workbook by using automation, VBA Console gets open too.

I don't want the user to see vba code written on ThisWorkbook module.

What should I do?

Thank you.

Rick.

 

[Norman Jones]

Hi Rick,

Try:

Application.VBE.MainWindow.Visible = False

 

[Guest]

Not really sure what you are meaning

 

[Guest]

Thank you Norman. I works fine.
Just a word to the others:

You should use
Application.VBE.MainWindow.Visible = False

AFTER any code that uses VBProject in Excel.

bye.

Rick.