Ryan,

Unfortunately, there is no good way to create a countdown timer that
displays in a worksheet cell. Using only native Excel/VBA, OnTime is the
only way to go. As you have seen, OnTime events are either postponed or
never executed (depending on the LatestTime parameter) if the user is doing
anything within a cell. If you expand your horizons to include the Windows
API, you can use native Windows timers, which have a millisecond resolution
in contrast with OnTime's one second resolution. Be warned, though, that if
the TimerProc callback function called by a Windows timer attempts to modify
any cell while the user is in Edit Mode, you will likely crash Excel and
loose any unsaved work. Both the OnTime method and Windows Timer API
functions are described at www.cpearson.com/Excel/OnTime.aspx.

is it possible to view the source code of an add-in?

If the add-in is an XLA add-in, it is protected only by VBA's *very* weak
protection. Google on "vba password" and you'll likely find ways and
freeware/shareware that can break a VBA password. If the add-in is a COM
add-in, no source code exists within the add-in.


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

"Ryan Ragno" wrote in message
...
Hi everyone,

I've spent a VERY long time sleuthing the web trying to find a count down
timer system (preferably that prints in the status bar of the workbook,
which
i already have a working counting timer i made that does this using the
OnTime method), that allows the user to continue
changing/copying/pasting/etc. whilst it counts down to zero from a
predefined
value. Although my own code uses it, you can not use the OnTime method for
this since the timer stops counting down while a user types something into
a
cell for example and takes more than a second to do so:

I have found a link of someone that has cracked this problem, using an
add-in:
http://www.tushar-mehta.com/excel/so...countdown.html

can this be accomplished without an addin? is it possible to view the
source
code of an add-in?

Thankyou for all of your help (in advance)