VBA Code assistance

Hi All

I'm back with a problem I need assistance with.

I have attached two files.

On opening the Workbook (Master), when I press the Generate No it automatically opens up a different workbook - (No Generator) which generates a new invoice no.
My problem however is that after the macro runs, both workbooks are closed and only the (No Generator) should close.

Can anyone assist. Here is the code for both workbooks:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is because of the below code:

Please Login or Register  to view this content.

Please use below:

Please Login or Register  to view this content.