Hi,

I also need some sort of error trapping here. If the
person missed doing the refresh at 24th and, for example
opened it on the 28th, I need the refresh to execute.
Somehow it has to check if it had refreshed on the 24th
and if not, and it's still within the same month, I need
it to be able to refresh then. But not anymore for the
rest of that month. I need help!!!








Private Sub Refresh_Button_Click()
If Date = DateSerial(Year(Date), Month(Date), 24)
Then
MsgBox "This is the 24th day of the Month. Your
data will be updated."

' RefreshMeters Macro
' Macro recorded 30/09/2003 by rhocarit
'
' Keyboard Shortcut: Ctrl+a
'
ActiveWorkbook.RefreshAll

Else
MsgBox "This is NOT the 24th day of the Month.
Your data has NOT been updated."
End If
End Sub