On way would be to use Application.OnTime to run a macro every second or two
(or more). If Excel is busy when the OnTime pops (e.g., another macro is
running or you are editing a cell), OnTime will defer the event until Excel
is ready. See www.cpearson.com/Excel/OnTime.aspx for more details about
working with OnTime.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Jase" wrote in message
...
I am trying to figure out a better more accurate way to run a clock with in
an excel sheet rather then using the NOW() function. I have a macro that
runs
off a website but the problem is it is a contantly running code and when i
try to execute other macro's while it runs it disables the clock macro and
debugs on me. Any suggestions?