Nice thats its possible. I tried to paste in the code but can't find how to
get it to run.

I have two macros in sheet one and two in sheet 2, all four I would like to
record in the same output table for macro usage.

Thanks again for your help


"Jacob Skaria" wrote:

You can write a separate procedure say WriteLog() to record the activity to
an external file or a hidden worksheet and call that from each click event of
the command button.

Private Sub CommandButton1_Click()
Call WriteLog()

End Sub


If this post helps click Yes
---------------
Jacob Skaria


"LiAD" wrote:

Hi,

is there the functionality in excel to record when a macro form button is
pushed?

I have, or will have a sheet with about 20 macros on it, all of which
perform simple + and - operations. I would like excel to record which macro
(by the macro name), the date and time at which any button was pushed, just
in one big long list one after another.

Is this possible?

Thanks