Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can't change what is in the drop-down for years, but you can limit the
year to 2009 on the calendar even if they select another year from the drop-down. Put the following code in the Worksheet code module that your calendar is on. Private Sub Calendar1_NewYear() Calendar1.Year = 2009 End Sub Mike F "Robert Crandal" wrote in message ... Is it possible to restrict the date ranges of the Calendar Control 8.0?? I only want the year 2009 to be selected from the drop down box. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
click on calendar control calendar but want to return the DAY of | Excel Programming | |||
monthview calendar question/ want the calendar to display weekdays only.. | Excel Programming | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Calendar Control | Excel Programming |