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
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.
One test is worth a thousand opinions.
Click the * below to say thanks.
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.Originally Posted by pal_slg
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
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Thank you all for your help.
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
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks