How does VBA finish with ThisWorkbook.Close ?

[Johndinho]

I am trying to finish some code by closing the workbook the VBA runs from.

Is this possible?

When I try to run the code with 1 workbook open, the code loops to PERSONAL.XLSB and gets stuck (code in there is specific to certain other workbooks).

I'm aware that ThisWorkbok.Close closes the vba before it reaches End Sub so the code cannot complete.

How do people get around this?

Thanks,

Johndinho

 

[Yongle]

Please post the code that gets stuck (enclosed in code tags - use # icon )