Calendar not Working on all Computers

[Runnin L8]

This is a shared worksheet. When I look at it I can manipulate the calendar, but for others it is just a non-interactive image.

I'm sure this has something to do with them not having this control in their computer, but is there a work around?

Thank you for you any advice!

Adam

[AlKey]

Maybe because Calendar in no longer available in Excel versions after 2007.

[Runnin L8]

Boo. I'm trying to give people a drop down selection box to enter the date by.

Is there a good option that would cross over multiple versions?

[Runnin L8]

I just checked and the end users are on 2007, the error code says links cannot be updated.

Is this fixable?

Thanks again,

Adam

[popipipo]

shared

I think this is the problem
Excel is not suitable for this; sooner or later you get problems with this.

[AlKey]

Here is a link that may be helpful to you

http://social.msdn.microsoft.com/For...p?forum=isvvba

[Runnin L8]

Thanks guys, time to do some reading!

[AlKey]

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation *.