I am after using a before close statement to check a cell's value and show a
message box if true. This would apply across all of my worksheets.

I.E.

If C1 = False

Then Display C1 needs to be True

But then still let them close. As an aside is there any way to make sure a
front worksheet opens no matter on which worksheet it is closed?

Many thanks.