Hi all,

I would like to schedule a macro to run at 22 minutes and 52 minutes past
the hour, so that the latest information available to the spreadsheet is
updated asap (usually available by 21 mins and 51 mins past the hour) to
remove the problem of the user forgetting to do so manually.

The macro is currently a Private Sub updated by the user 'as and when' by
clicking an embedded button on a worksheet, so I would like the solution to
recognise if the user is trying to update before the next info becomes
available (to avoid duplicating info unnecessarily).  (In some cases, there
may be a need for the user to update additionally outside of these
parameters, so the button will have to remain).

If possible, I would prefer not to have this in a separate incidence of
Excel...

Any ideas please??

Thanks,
Ewan.