Shred Dude
12-02-2010, 05:56 PM
I'm stumped on this one.
I have a workbook that uses DatePicker and MonthView controls from the MSCOMCT2.OCX class. All is well on every machine I run it on accept one, and of course this turns out to be the notebook of the guy paying the bills!
On his MacBook, running Windows7 in Dual boot mode, with Excel 2010, I can only seem to access the DatePicker or MonthView control when it is encapsulated in a UserForm, in any workbook, not just the one I've created.
I successfully registered MSCOMCT2.OCX with regsvr32 (as administrator) on this machine to even get to this point.
Now, my workbook operates OK on that machine where those controls are in a userform, but not where they are embedded on a sheet. Further investigation reveals that the VBA project doesn't compile on this machine, citing inabilities to locate the referenced control in the worksheet code modules.
On this same machine, if I start a new workbook, and attempt to insert a Datepicker or Monthview control directly onto a worksheet, I get a "Cannot Insert Control" error window. However, if I go into the VBE and create a userform for this new workbook, I can add both controls to the UserForm and run the UserForm error free.
The fact that the controls even appear in the Additional Controls selection window makes me believe they are successfully registered. Furthermore, I can use them within userforms. So, what's preventing me from using them on the Worksheet layer, on this particular machine???
I've never had this one before. Anyone have any ideas?
Thanks,
Shred
I have a workbook that uses DatePicker and MonthView controls from the MSCOMCT2.OCX class. All is well on every machine I run it on accept one, and of course this turns out to be the notebook of the guy paying the bills!
On his MacBook, running Windows7 in Dual boot mode, with Excel 2010, I can only seem to access the DatePicker or MonthView control when it is encapsulated in a UserForm, in any workbook, not just the one I've created.
I successfully registered MSCOMCT2.OCX with regsvr32 (as administrator) on this machine to even get to this point.
Now, my workbook operates OK on that machine where those controls are in a userform, but not where they are embedded on a sheet. Further investigation reveals that the VBA project doesn't compile on this machine, citing inabilities to locate the referenced control in the worksheet code modules.
On this same machine, if I start a new workbook, and attempt to insert a Datepicker or Monthview control directly onto a worksheet, I get a "Cannot Insert Control" error window. However, if I go into the VBE and create a userform for this new workbook, I can add both controls to the UserForm and run the UserForm error free.
The fact that the controls even appear in the Additional Controls selection window makes me believe they are successfully registered. Furthermore, I can use them within userforms. So, what's preventing me from using them on the Worksheet layer, on this particular machine???
I've never had this one before. Anyone have any ideas?
Thanks,
Shred