**Newbie Question
is it possible to get excel to save the workbook at set times, as in evry hour on the hour, not after 60 mins but on the hour realtime if you know what I mean?
I have a shared workbook that needs to update on the hour, 14 people complete within the book, each have a seperate sheet to complete with a master sheet which roles up their info, but I need it to save automatically
the built in autosave wont do it so I'm hoping someone knows a VBA piece I could drop in, have tried googling it but come up with nothing that works
thanks in anticipation
is it possible to get excel to save the workbook at set times, as in evry hour on the hour, not after 60 mins but on the hour realtime if you know what I mean?
I have a shared workbook that needs to update on the hour, 14 people complete within the book, each have a seperate sheet to complete with a master sheet which roles up their info, but I need it to save automatically
the built in autosave wont do it so I'm hoping someone knows a VBA piece I could drop in, have tried googling it but come up with nothing that works
thanks in anticipation