Where do I copy the Macro to for it to Run

[Roj47]

Ok... I am embarrassed and can not find where to put the Macro.

I found a useful bit of countdown code on here and have tried addiing as a new Macro and also into the tab option, but the cell is not counting down.

Where do you insert Macros such as this one to have them work?

Thank you.

 

[crook_101]

HI,

I take it that you are talking about VB code......, the actual location depends on what you want it to do however I assume that this will be a macro that you want to call up??

With excel open press "Alt & F11">> Insert>>Module paste your code in here then press Alt & Q to close.

Run the macro (Alt & F8) to bring the macro box up and select your macro.

HTH

Ian

 

[Roj47]

Thank you. Did not know about Alt-F11.

This is the link to the thread for an automatic countdown, which I am assuming runs in real-time without my intervention or input.

Kind regards,

http://www.mrexcel.com/forum/showthread.php?t=547762