I have an Excel spreadsheet that contains VBA code for a popup calendar widget. It works fine in Windows Excel versions 2007 and 2010. However, someone tried to use the document in Mac Excel 2011, and the calendar widget does not pop up. Could someone please help me troubleshoot to make things compatible for as many systems as possible?

Here is the code we are using (it also includes code for widening columns):

Please Login or Register  to view this content.
There was also a secondary issue about data validation drop down fields. Our Mac user said that it took several clicks to choose the drop down from a cell with data validation cells. Is there a way to minimize the number of clicks needed to select an option? (This may just be something not inherently changeable - I can't verify since I don't have a Mac, but am hoping that someone might know if this is an issue to troubleshoot).

Thank you in advance!