Calendar Control 11 - Allow Weekending Date Only

[steve1262]

Does anyone have a code that will only allow the user to select the weekending date (Sunday)?

Thank you in advance.

Steve

 

[Jon von der Heyden]

Hi Steve,

Using data -> Validation -> Allow: Custom

Formula is: =WEEKDAY(A1,1)=1

Where A1 is the cell you want to restrict to weekending date. You can apply to a range of cells (copy, paste special->validation to extend if you want).

Regards,
Jon

 

[steve1262]

I think because I am using the calendar control as part of VBA code it does not seem to be working.

I was hoping to add a code to the control that only allowed the user to select a weekending date (all other dates would be dimmed)??