Assign Macro to Action Button.

[sg2012]

Hi All

I have a Scenario:
In Tm1 Perspectives I have 2 Action Buttons.
When I click on Action Button,TIs run.
When I click the Button, I want the Start Timestamp to be recorded in the next cell.
I wrote Macros for recording Timestamp.
But when I run MAcro for 2nd Action Button,all the Macros get refreshed.

I wrote following Code in VBA.

Private Sub TIButton1_Click()
Application.Run "Macro_Time"
End Sub

where TIButton1 is the name of Action Button.
and Macro_Time is the name of Macro.

[kpk]

Why do you need the macro and macro button for that?
Instead of writing the timestamp into an Excel cell I suggest to write it in a TM1 cube.