Need to close VBE before save

[Tiger20]

My file saves correctly when the VBE is closed, however if the VBE is open the closing code functions and saves but the VBE screen will display an Out of Memory warning. When the OK is clicked on that warning Excel has stopped and then goes through a restart. The file has been saved correctly.
In trying to use code to close the VBE.
I've attempted

Please Login or Register  to view this content.

When put into a macro this just gives a ping sound, and nothing else appears to happen.
How can I close the VBE using code?

[:) Sixthsense :)]

What happens if you try the below one.

Please Login or Register  to view this content.

[Tiger20]

Thanks but - Fails with message Programmatic access to Visual Basic Project is not trusted

[:) Sixthsense :)]

Refer the below screenshot to know how to enable Trust Access setting in excel VBA.

[Tiger20]

Yes works as required - Thanks
Presume I need to wrap an IF around it having recognised me so that other don't bomb out.
I can do that if required, just a Yes or No
Thanks in advance of that, and I'll do the Solved and rep things now.

[:) Sixthsense :)]

I believe it won't throw any errors if the VBE is not in open or in hidden.

Anyhow here is the If condition to check whether VBE is in open and if it is in open then it will hide the window.

Please Login or Register  to view this content.

[Tiger20]

Thanks again, a much better solution than mine which was just to recognise me.

[Tiger20]

Needed to implement identify who was using so as to avoid the Application.VBE if some using. This for users who were unlikely to ever have VBE open and selecting the Trust Center setting was too scary.
All good though.