Hi Stomps,
Calender1 is not included in your code. Is it an add-in? If so can you post it or an address for it.
Re triggering the payment code, are you happy with a button or is there a cell change which would trigger the macro.