Another way to create a calendar in Excel is by inserting a Calendar Control. The Calendar Control is an ActiveX control. If you work in Access, you have probably used controls, such as combo and text box controls. This method allows you to insert a calendar to an area of the worksheet. You can refer to this calendar at any time, moving forward or backward from month to month.
To add a Calendar Control to Excel 2003, begin by clicking on a cell in the area of the spreadsheet where you want to make a calendar. Go to the Insert menu and click on Object. On the Create New tab of the Object dialog box, click Calendar Control and then click OK.
click to enlarge
In Excel 2007, go to the
Developer tab of the ribbon and click
Insert. Select
ActiveX Controls and then
More Controls. Select
Calendar Control and click
OK.
click to enlarge
If you don't see the Developer tab, click the
Office Button and then click
Excel Options at the bottom of the menu. On the
Popular tab of the Excel Options window, select
Show Developer Tab in Ribbon.
If you do not see the Calendar Control option in either version of Excel, it may be because it is installed with Access. You can download the Control here.
The calendar will open in Design View. To make the calendar a bit more custom, remain in Design View. Right click the Calendar Control, point to Calendar Object and select Properties. Use settings on the Calendar Properties dialog to make the Calendar in your Excel spreadsheet look the way you want. You can use VBA to control how the calendar looks and acts as well. Simply double click the Calendar Control to open Visual Basic.
click to enlarge
