Excel Calendar to ONLY allow for Tuesday's in any month to be selected

  • Thread starter Thread starter Corey ....
  • Start date Start date
C

Corey ....

Is there a way to ONLY enable a Tuesday to be selected from a Calendar, with
no other days of the week enabled ?

If so how can i do this?

Corey....
 
I think this BeforeUpdate event code for the Calendar will do what you
want...

Private Sub Calendar1_BeforeUpdate(Cancel As Integer)
Calendar1.Value = Calendar1.Value - Weekday(Calendar1.Value) + 3
End Sub

Rick
 
Unlock Tuesday (Format-Cells-Protection-uncheck 'Locked') and protect your
sheet.

JM
 
Back
Top