Jeffrey Lebowski
Member
Hi everyone,
I was inspired by this interesting article to incorporate a pop-up calendar in a file I have created for a colleague. I opted not to use the Microsoft Date and Time Picker Control 6.0 and instead use the Microsoft MonthView Control 6.0.
The code uses a named range and SelectionChange event. If a cell in the named range is selected, the pop-up calendar displays. This works great in my version of Excel...Excel 2010.
My colleague uses Excel 2013, and the code is not working for him. Upon opening the workbook, he receives an error message "Could not load some objects because they are not available on this machine." And VBE opens with the UserForm_Initialize() Procedure highlighted.
Would someone please shed some light on this issue? Is there a different name for this Calendar control in Excel 2013? How could I modify the existing code to function properly in Excel 2013?
Please see the attached sample file.
Thanks!
I was inspired by this interesting article to incorporate a pop-up calendar in a file I have created for a colleague. I opted not to use the Microsoft Date and Time Picker Control 6.0 and instead use the Microsoft MonthView Control 6.0.
The code uses a named range and SelectionChange event. If a cell in the named range is selected, the pop-up calendar displays. This works great in my version of Excel...Excel 2010.
My colleague uses Excel 2013, and the code is not working for him. Upon opening the workbook, he receives an error message "Could not load some objects because they are not available on this machine." And VBE opens with the UserForm_Initialize() Procedure highlighted.
Would someone please shed some light on this issue? Is there a different name for this Calendar control in Excel 2013? How could I modify the existing code to function properly in Excel 2013?
Please see the attached sample file.
Thanks!