Solved: WEEK DAY REMINDER

[BENSON]

A simalar question to a previous post. how would I change the code below to give me a MSG BOX if the day of the week was a Tuesday when the week book was opened

THKS

[VBA]

Private Sub Workbook_Open()
If Day(Date) >= 27 Then MsgBox "TO DAY IS TUESDAY RESET DATES."
End Sub

[/VBA]

[RichardSchollar]

Hi

[vba]Private Sub Workbook_Open()
If Weekday(Date) = vbTuesday Then MsgBox "TODAY IS TUESDAY RESET DATES."
End Sub [/vba]

Richard

[Bob Phillips]

[vba]

Private Sub Workbook_Open()
If Weekday(Date, vbSunday) =vbTuesday Then MsgBox "TO DAY IS TUESDAY RESET DATES."
End Sub
[/vba]

[BENSON]

THANKS ALOT GUYS