The count down can only work using a VBA based timer that fires at periodic intervals. For that, you'll need to run a macro from the moment the workbook opens, till the time it closes.