Add this to Thisworkbook module if you mean when you open workBOOK.

Private Sub Workbook_Open()
If Weekday(Now) = 4 Or Weekday(Now) = 5 Then
MsgBox "send report immediately"
End If
End Sub

If you really meant workSHEET then ignore above and add this to
worksheet module.

Private Sub Worksheet_Activate()
If Weekday(Now) = 4 Or Weekday(Now) = 5 Then
MsgBox "send report immediately"
End If
End Sub


Gord


On Wed, 31 Jul 2013 23:39:20 -0700 (PDT), wrote:

On Friday, February 1, 2008 9:09:59 PM UTC+4, Gord Dibben wrote:
Yes


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 20:33:01 -0800, ed wrote:

Sir,

I want to creat a popup reminder when we open worksheet, like every wednesday & thursday like " report to be sent urgently", u can specify cell A1 or any for values

pls reply