Code is opening developer window

[zoog25]

Hello All,

Here is my situation. I currently have code that brings in a worksheet from a different workbook and adds code to the worksheet. The problem is that after it runs this code, the developer window opens up to shows that it has run. What do i do in order to prevent this from happening. The reason being is that people using this workbook program don't need to be looking at the code and i'm sure they will thing there is an error when there isn't Thank you.

 

[ranman256]

lock it wth a password
but why does it open? Is it stopping on a line? (ghost break point)

 

[zoog25]

Hello ranman256.,
I have code that writes code on the new sheets. I believe because the code is written, that is triggering to have the editor pop up. I found coding online to fix this situation which is the following.

ThisWorkbook.VBProject.VBE.MainWindow.Visible = False

So hopefully this will help others.