You would use the beforeclose event.

http://www.cpearson.com/excel/events.htm for an overview of events.

Environ("Username")

tells you the login id

demo'd from the immediate window:
? environ("Username")
OgilvyTW

--
Regards,
Tom Ogilvy


"TheRook" wrote:

This may be an easy one but I am very new to Macros.

I would like a promt/Window/box, whatever tou call it to come on screen when
closing the spreadsheet reminding me to ensure that the worksheet is
protected.

Is this possible?

If I can go onestep further I would like it to appear when only certain
people cloes the spreadsheet.

regards