I have created a 2007 Excel XLSM Workbook with Calendar controls. Yesterday, I had one of the users test the workbook from their desktop. The workbook is stored in a public folder.
After the AutoOpen macro navigated to the Sheet with the Calendar Controls, the user could not update the dates. The user had no control over the Calendar.
What can I do to update the user's privileges in Excel to allow the use of this control?