View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.