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