Not sure of the code, but can you not store the value of the cell in a public
variable at the time the cell is selected?
--
BerbatovIsGod


"bigwheel" wrote:

You're welcome and thanks for the feedback

"Paige" wrote:

Works like a charm! Thanks so very very much - you are a lifesaver!!!

"bigwheel" wrote:

1 & 2) Enter the instruction Worksheets("sheet1").Select before the line
Application.EnableEvents = True

3 & 4) Change the line to Activecell.Value = Application.Username

5) Can't think of a way because once excel has noticed that a change has
been made, it's already happened (but I'll keep thinking!!)