Evening guys, 1st post on here so please be gentle!
I have read various post now, but have not been successful in what I am wanting to achieve. To put it in simple terms I wan to prevent the closing of a workbook if Sheet1 A1 does not contain the word 'Yes'.
All the post I have found have managed to show a prompt to highlight to the user that the cell doesnt contain 'yes' but once 'OK' is selected it closes the workbook. I am wanting the workbook to to be able to close until A1 contains 'yes'
Hope this makes sense and is possible, I have spent that many hours googling and trying my eyes are stinging
Mr Shelby