Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Leith Ross" wrote This will inset a Month View on the Active Sheet. Making it interactive is another issue. You are right about making it interactive. I assume there is something I'm missing. With MonthView embedded in the WorkSheet, MonthView events are fired as expected: Private WithEvents myMonthview As MonthView Private oleMonthView As OLEObject Sub whatever() Set oleMonthView = aSheet.OLEObjects.Item("MonthView1") Set myMonthview = oleMonthView.Object end sub However, when creating a MonthView this way, the MonthView events are not fired: (without myMonthview_DateClick event, this is useless) Private WithEvents myMonthview As MonthView Private oleMonthView As OLEObject Sub whatever() Set oleMonthView = aSheet.OLEObjects.Add _ (ClassType:="MSComCtl2.MonthView") Set myMonthview = oleMonthView.Object end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
monthview object or ?? | Excel Discussion (Misc queries) | |||
OLEObjects | Excel Programming | |||
monthview calendar question/ want the calendar to display weekdays only.. | Excel Programming | |||
OLEObjects .. again | Excel Programming | |||
Monthview AxtiveX | Excel Programming |