Issues with opening or closing of a workbook

Hi all

wanted to ensure user enters some value in range("A1") for the workbook to be closed.

The workbook should be open until some value is updated a1. I have tried with wb.open , close it
doesnt give me the result . Below is the code

Please Login or Register  to view this content.

Not sure to have a clear understanding of what you want versus the code you propose but try

In a module put

Please Login or Register  to view this content.

in Thisworkbook module put

Please Login or Register  to view this content.

Thank you PCI, Ptmuldon for your help

You're welcome and thx for the rep ...!