Recording Changes Made to Worksheet
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!!)
|