View Single Post
 
Old 08-08-2011, 08:46 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
In the Validate_Fields() Function change:

If Not Weekday(Range("B7").Value) = vbMonday Then
MsgBox "Start Date must be a Monday (week beginning)", vbInformation

to

If Not Weekday(Range("B7").Value) = vbMonday Or vbTuesday Or vbWednesday Or vbThursday Or vbFriday Then
MsgBox "Start Date must be a Weekday", vbInformation

I think this will give you what you want. I am unable to step through the code because there are missing sheets.

Hope this helps.
Good luck.
Tony(OTPM)
Reply With Quote