Excel macro question

[waynethebrayn]

Please could somebody tell me how to find out if a macro is running in excel?

I have written some code to refresh the quick pick list every 3 hours for each tab linked to BA. So now I open BA, set the excel links, wait for excel to open and settle down, and then manually run the macro.

There are occasions when I may forget to do this, or times when I may run it twice! Is there a quick way of monitoring what is going on? I prefer not to use message boxes etc.

Thanks in advance for your help.

[throwmeadisc]

Hi Wayne,

I just have a cell that I use to tell me when a macro was last run, it's just as simple as......

Code: Select all

Sub RunMacro()

'Run Code



Sheet1.Range("A1").Value = Format(Now, "dd/mm/yyyy hh:mm:ss")

End Sub



Change up your destination cell as you wish..

Al

[waynethebrayn]

Al,

That seems to do the trick, thanks very much for your help.

Wayne