This is a new feature and we can’t wait to hear your feedback. Is it useful for your tasks? Is it easy to use? Just let us know via website or email us.
Use with caution: beta features may contain some bugs and rough edges. To test the feature, take a free trial or update XLTools.
Embed a sharable date picker into your Excel spreadsheets and make it available to other users
- Embed the Calendar into specific workbooks you share
- Define date/time format and other settings to control data input
- The Calendar is intuitive to use: click on a cell – pick a date
Before you begin, add Embedded Calendar to Excel
How to embed the Calendar into Excel workbook
- Or: File Options Trust Center Trust Center Settings Macro Settings Check Trust access to the VBA project object model.
- Open the workbook, where you want to embed the date picker.
Although *.XLS format also supports macros, and you can embed the Calendar into *.XLS workbook, we don't recommend it. *.XLS is a vulnerable older Excel format, and when you share or send such spreadsheet to other users, it may be blocked by their antivirus programs as malware.
How to change settings of the Embedded Calendar
- Open XLTools tab Settings Date/Time tab.Or: click the arrow button in the corner of the Date & Time group.
- Change settings as you need.
- Click OK Done!
- Check the box Display the calendar and clock icons next to cells to make the date picker available from the popup icon. The icon will pop up next to the cells with date/time format. Clicking on the icon will bring out the Calendar.
- Check the box Display “Insert Date” in context menu to make the Calendar accessible from the right-click context menu. Users can insert dates only.
- Check the box Display “Insert Time” in context menu to make the Clock accessible from the right-click context menu. Users can insert time only.
- Check the box Display “Insert Date & Time” in context menu to make the Calendar together with the Clock accessible from the right-click context menu. Users can insert dates together with time.
- Check the box Auto-increment dates when used in ranges, and when users populate entire ranges, date values will be inserted consecutively with 1 day increments.
- Check the box Auto-increment time when used in ranges and when users populate entire ranges, the time values will be inserted consecutively with 1 hour increments.
- Check the box Use this format as default, and all date and time values inserted with the Embedded Calendar will follow the format you specified. You can set the date/time format common in your country or language, or set your own custom format.
How to remove the Embedded Calendar from a workbook
- Open the workbook with the Embedded Calendar.
- XLTools tab In the Date & Time group, open the drop-down list Click Remove from workbook.
If I share the workbook, will the Calendar be available to other users?
- Other people can use the Embedded Calendar in your specific workbook
- The Calendar will work exactly as you have specified in the settings
- Users cannot change the settings of the Embedded Calendar
- Excel 2010 – 2019, installed desktop versions. Not suitable for mobile and web versions of Excel.
- Microsoft .NET Framework 4.0 and higher. This is a Microsoft prerequisite necessary for the Embedded Calendar to function properly. Usually it is already installed on users' computers.
- Windows 7 – 10
What to keep in mind when you share the workbook with others
- No file can be 100% secure when transmitted over the internet. When you share the spreadsheet with other people, use the channels you trust.
- We cannot guarantee that when users receive the workbook with Embedded Calendar, their systems will not block the file. Computer systems and cloud storages have various security policies to treat macros. Some may raise red flags or block macros as malware.
- We recommend that you embed the Calendar into *.XLSM workbooks, which is a more secure format compared to *.XLS – older and more vulnerable Excel format.
There is a security warning, what does it mean?
To enable macros in a specific workbook, click Enable Content on Excel message bar: