how to change calendar sheet object displaying month-date-year to only month-year

[DNsingh]

Hi All,

I have a calendar object in my sheet, when I click it shows a calendar selection for date, month and  year. Below is the current calendar object I m using:

I want  to change it as for selecting month and year only. I want to show only month and year options to select.

Is it possible to do so???

Please help!

[Vegar]

I don't think this object has support for what you are trying to do. You could  however just display the two listboxes [Year]  and [Month] in the application instead of the calendar object. It will give you the functionality you are looking for.