Automatically reset spreadsheet daily

[Flammabubble]

Hi there, so this is my first time on the forums, I'm currently creating a spreadsheet that needs to reset the values of specific cells to 0 on a daily basis.
I have created a module with the code below that is currently assigned to a button so I can manually reset

Please Login or Register  to view this content.

And I now need a code to activate that daily. I have searched around and found the below, which I have put into the workbook VBA and tried to test but it does not appear to be working.

Please Login or Register  to view this content.

Would somebody be able to assist?

[pjwhitfield]

Application.OnTime only works if the spreadsheet is open at that time which therefore causes problems if people are in it and it changes or for that matter the fact it may not be changed when they 1st open it.

To get around this Ive usually added an OnOpen event which checks a cell somewhere hidden away to see when it was last reset, if its not today then reset the values and amend the cell to show todays date before saving the sheet.

[Flammabubble]

This is for a work tracker spreadsheet, so some people will be leaving the spreadsheet open with the computer locked and others shut the computer down. I need it to reset before work each morning (so it can reset anywhere from 6pm to 7am really, nobody will be on the sheet at the time) but as different people will be in different states, is there a way to fix it?

[Flammabubble]

Additionally, even with leaving the spreadsheet open it does not run the 'reset' function and I'm not quite sure why

[Flammabubble]

Figured it out - needed the below code in my module rather than what I had

Please Login or Register  to view this content.