I have an app - where I am creating another spreadsheet with pivot
tables on it, then adding command buttons and programatically putting
code behind those buttons.

When this is done - the VBE window is opened - which I would like to
close systematically.

I can hide it using the following code which works.

Application.VBE.MainWindow.Visible = False

But if I put in the exact same place the following code to close it -
it bombs.

Application.VBE.MainWindow.Close

The error I get is "Run-time error '-2147467259 (80004005)':"
"System Error &H80004005 (-2147467259).
Unspecified error"

Thanks for any help you can provide....