calendar control

[Lynn]

any idea why Calender Control cannot be clicked?

 

[Rick Rothstein]

Your question is a lot like if I asked you "Any idea why my car won't
start?"... in both cases, I'm pretty sure a lot more information would be
needed in to provide an answer.

 

[Lynn]

i am using Calender Control with a marco.
on 1 PC i can click on the calendar and the date will be shown on the
cell. But on another PC the calendar cannot be clicked

 

[Dave Peterson]

Did the second pc allow macros to run?

i am using Calender Control with a marco.
on 1 PC i can click on the calendar and the date will be shown on the
cell. But on another PC the calendar cannot be clicked

 

[Lynn]

yes. i even set security to low, but when i click on the calendar
button it does not click

 

[Dave Peterson]

Do you have multiple windows open (window|new window, window|arrange) in the
problem version of excel?

 

[Rick Rothstein]

I have no way of testing this, but I think it is a relevant question
(hopefully someone will know for sure based on your answer)... are both
computers running the same version of Excel?

--
Rick (MVP - Excel)


yes. i even set security to low, but when i click on the calendar
button it does not click

 

[Dave Peterson]

And to followup...

Is the calendar control a legal control on each pc?

The calendar control that comes with Office is part of Access. If the offending
pc doesn't have access installed, then maybe that "calendar control" has turned
to a picture for them.