I am currently using Excel 2003 to develop a workbook that will be used by many users having different versions of excel.
I used the Excel calendar in my workbook for one of the sheets (adding the Microsoft Calendar Control 11.0). (Same idea as http://www.ozgrid.com/VBA/excel-calendar-dates.htm)
I believe when someone installs the calendar, Microsoft puts the file "MSCAL.OCX" onto your c drive, in path "C:\Program Files\Microsoft Office\OFFICE11". (at least it did for me)
It is used to control the date format that users enter in the cell. When the user clicks the cell, the calendar appears, and once they select the date, the date gets entered in the cell (shown as 17-Nov-2007)
Everything was fine until I recently tried opening it with Excel 2000 on another workstation and got an error. (I am currently trying to find someone with Office 2000 that can open my workbook so I can enter the complete error message on here) OR it opens without error, but when you click on the cell to activate the calendar, it shows a blank calendar without dates.
It appears that if a user without Office 2003 tries to open up my excel file that does not have the calendar installed (or the OCX file), they will get an error. Plus different excel versions have different calendar versions (ie 9, 10, 11).
These users are not very tech savvy so it probably won't be possible to email them the OCX file and teach them each how to copy it onto the proper folder, especially since they are located all over the country and I noticed some users don't have the "Office11" subfolder, only "Office"
I wanted to know how I could work around keeping my calendar installed in the workbook and avoiding this problem when users with different versions open it. Is there any other calendar function I am not aware of?