Some questions concerning the .OnTime event in Excel

[Bezzie]

If I set

Please Login or Register  to view this content.

Will SubToRun run every day at 15h00 or will it only run today at 15:h00?
Must it be reset every time to run the next day at 15h00?

[JosephP]

it must be reset every time

[Bezzie]

Thanks JosephP. Is it necessary to cleanup after the timer or can I just stop the timer on exiting the workbook?

[JosephP]

if the code has been set to run again and you wish to cancel it you can use

Please Login or Register  to view this content.

or simply close excel completely

[Bezzie]

Thank you very much for the info.