Help Auto Calling Next Market..pls

[Sailor]

Does anybody have a spreadsheet macro that will call the next market automatically once the previous market has been closed. I have a macro that will do this but I have to run it manually each time. What I need is a macro that will run all the time the spreadsheet is open...is that possible.

Many thanks

[osknows]

Hello Sailor,

I never thought I'd hear myself say that! This link has some code to do what you want http://www.gruss-software.co.uk/forum/v ... php?t=4984

Os

[Sailor]

MAny thanks Osknows, will try it out

[greenfingers]

Hello Sailor,

I never thought I'd hear myself say that!

Os

[Sailor]

Thanks Os, works great