Open event to call procedure ONLY on Monday
Have you considered using the WEEKDAY worksheet function in your worksheet_open event? You would put this in the "ThisWorkbook"
module. Your code would start with:
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
dyDay = Weekday(Now(), 1)
If dyDay = 2 Then
' some code here
End If
End Sub
--
RMC,CPA
"Steph" wrote in message ...
Hello everyone. I would like to create a workbook open event that calls a
procedure within the same workbook ONLY if the workbook is opened on a
Monday. All other days the open event would call nothing. Is this
possible? Thanks!
|