Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 2007.
Can someone tell me how to add a MonthView oleObject to a worksheet using VBA? I have tried: (aSheet has been set to the ActiveSheet) Set oleMonthView = aSheet.OLEObjects.Add _ (ClassType:="forms.MonthView") Set oleMonthView = aSheet.OLEObjects.Add _ (ClassType:="forms.MonthView.1") Set oleMonthView = aSheet.OLEObjects.Add _ (ClassType:="forms.microsoft monthview control") + a few other variations. I always get Runtime error '1004': Cannot insert object. |
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 |