make VbA invisible
 

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.

make VbA invisible
 

Hi Rick,

Try:

Application.VBE.MainWindow.Visible = False


---
Regards,
Norman


"newbie in hell" wrote in message
...
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.

make VbA invisible
 

Not really sure what you are meaning

"newbie in hell" wrote:

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.

make VbA invisible
 

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.

"Norman Jones" wrote:

Hi Rick,

Try:

Application.VBE.MainWindow.Visible = False


---
Regards,
Norman


"newbie in hell" wrote in message
...
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.