JohnSearcy
07-02-2010, 06:25 PM
I have a problem (due to a botched registery cleaning). I can no longer put the Monthview Control on a userform. It comes with an error message - %1 could not be found. Yesterday, I tried reloading Excel and repairing and this apparently didn't help. Is there something I missed on that, or would an entire system restore work (which I really don't want to do)?
Thanks
ps. Excel 2003
Cerian Knight
07-02-2010, 07:13 PM
The file MSCOMCT2.OCX must exist in the system folder (e.g., C:\WINDOWS\system32\MSCOMCT2.OCX).
Also, these keys should exist in the system registry:
*HKEY_CLASSES_ROOT\MSComCtl2.MonthView
HKEY_CLASSES_ROOT\MSComCtl2.MonthView.2
*HKEY_CLASSES_ROOT\CLSID\{232E456A-87C3-11D1-8BE3-0000F8754DA1}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{232E456A-87C3-11D1-8BE3-0000F8754DA1}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\MSComCtl2.MonthView
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\MSComCtl2.MonthView.2
Post regedit exports of the * items here, if you like, and I'll have a look. Otherwise, a pre-cleaning restore point should take care of it.
JohnSearcy
07-02-2010, 07:40 PM
Thanks, Cerian. All of those values exist in there exactly as you have. Do you still want me to post them?
Cerian Knight
07-02-2010, 10:50 PM
Knowing the subkey values might be useful if you'd like to post the export .reg files. Are there any other 'Additional Controls' that exhibit similar behavior (e.g., Microsoft Flat Scrollbar, Microsoft ImageList, etc.)?