Application.ScreenUpdating = False
Workbooks.OpenText Filename:="C:\Macro Run Dates.xls"
ActiveCell = "Macro Name"
ActiveCell = "=today()"
Workbooks("Macro Run Dates.xls").Save
Workbooks("Macro Run Dates.xls").Close
Application.ScreenUpdating = True
I figured I could put that at the beginning of each of my macros, and replace "Macro Name" with that sub's name. OR, if I knew how to automatically have it enter the name of the macro, I could just call the log macro at the beginning of each one. Is there a way to do that?