Hi


Is there a way to log the date time a macro was run?

For example, i have a button that fires off a macro, the user selects when
to hit the button, but the choice to hit it may be based on how much time has
elapsed since it was last hit. If i could put a date / time in an adjacent
cell to the button, users could make a more informed choice.

Any help gratefully recieved. If you need more info, please do not hesitate
to contact me


cheers


jb

Within the macro include something like:

Range("A1").Value = Now()

pick any cell in place of A1
--
Gary''s Student


"JB2010" wrote:

Hi


Is there a way to log the date time a macro was run?

For example, i have a button that fires off a macro, the user selects when
to hit the button, but the choice to hit it may be based on how much time has
elapsed since it was last hit. If i could put a date / time in an adjacent
cell to the button, users could make a more informed choice.

Any help gratefully recieved. If you need more info, please do not hesitate
to contact me


cheers


jb