Message on close

[amna77]

hi, I am trying to create a message when some one close the file then mesasge should come up.
ok if some one opens that file, and make some changes, then when he close the file, I want a message if he did not put his name in cell U1. basically I want to capture a name in cell U1, like who update this file last time.

Thanks in advance
Amna

 

[amna77]

Thats where I have right now, in ThisWorkBook Module, and beforeclose event.