'Since changing to Windows 10 an Excel 2010 program with VBA macros does not run and says 'Missing- Microsoft Windows Common Controls - 2 6.0 (SP6)'. When I checked in ‘Reference’, I could see ‘MISSING: Microsoft Windows Common Controls-2.6.0 (SP6)’. This macro runs smoothly at another PC however at another PC I did not see this particular reference ticked. Can anyone please help me in this. How do I resolve this. One of our clients has several VBA macros in excel 2013 with the date picker control in VBA. All are working fine in 2008R2. He copied the same VBA and tried in 2012R2 /excel 2013. Date picker control was not available. I did some research and learned that Microsoft packed the control as.ocx which we need to download/copy and register it.
- Microsoft Monthview Control 6 0 Excel 2016 Missing Page
- Microsoft Monthview Control 6 0 Excel 2016 Missing File
- Microsoft Monthview Control 6 0 Excel 2016 Missing Key
- Microsoft Monthview Control 6.0 Excel 2016 Missing
I'm using Microsoft Excel 365
I cant find the [Microsoft MonthView control 6.0 (SP4)] tool in More Controls list.
I tried the following steps:
>>Download the MSCOMCT2.OCX
>> copy MSCOMCT2.OCX file and paste it in C:WindowsSystem32.
>> open Excel.
>> Go to “Developer” Tab. Click on “Insert” in “Controls” group.
>> Click on “More Controls”
>> then click on “Register Custom” Button.
>> then in C:WindowsSystem32 find the “MSCOMCT2.cab” and click on “ok” button.
But got a message: Cannot register this control.
In the posting “Insert a Drop Down Calendar Menu In Excel – Choose a Date!” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).
Looking for it? Trying to figure out where to download it from? If it is not installed on your system you can download it here.
To unzip a CAB file simply follow the directions in the posting “A Free Alternative to Winzip or WinRar: 7-Zip”
Once the file is unzipped simply run the MSCOMCT2.BAT batch file!
Microsoft Monthview Control 6 0 Excel 2016 Missing Page
CategoriesUncategorized
Microsoft Monthview Control 6 0 Excel 2016 Missing File
Microsoft Monthview Control 6 0 Excel 2016 Missing Key
Tags7-ZipCalendarDateDrop DownExcelMicrosoftTimewinrarwinzip