Embedded calender in Excel Pro + 2007

**pal_slg** · 01-28-2012, 11:30 AM

Hi

I am using excel 2007 in one of my machine and have used= EMBED("MSComCtl2.DTPicker.2","") for embedded calender. This is working fine in the 2007 version but when I transferred the file to my other machine, which has a Professional Plus 2007 version, I am unable to use the date feature. Is there any other way of doing this (Without using VB Please)?

Thanks for any help.

Pal

**MarvinP** · 01-28-2012, 01:05 PM

Hi pal_slg,

There has been many changes to the old Calendar control and now it is as you find, DTPicker. I believe the old ActiveX Control of Cal had some security issues.
Here is a thread about the problems http://www.teachexcel.com/excel-help...o.php?i=196205
Find attached an example I made using 2010.

**sesss** · 01-28-2012, 07:35 PM

Originally Posted by pal_slg

Hi

I am using excel 2007 in one of my machine and have used= EMBED("MSComCtl2.DTPicker.2","r4i") for embedded calender. This is working fine in the 2007 version but when I transferred the file to my other r4 machine, which has a Professional Plus 2007 version, I am unable to use the date feature. Is there any other way of doing this (Without using VB Please)?

Thanks for any help.

Pal

Use a non-ActiveX date picker. There are loads available. This means that the Calendar is constructed from a user form in your VBA application and you dont have to rely on users having MS or third party controls (OCX files) on their machine. Do a search on Google.

**royUK** · 01-29-2012, 05:24 AM

You need to use VBA. There's a free addin which you can install, then the workbook will not require VBA.

Free Date Picker

Thre's also a userform calendar there as well

**pal_slg** · 01-29-2012, 10:06 AM

Thank you all for your help.

**royUK** · 01-29-2012, 12:34 PM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save