MS Excel: Active X Forms Not Working for users

I have created a 2007 Excel XLSM Workbook with Calendar controls.  Yesterday, I had one of the users test the workbook from their desktop.  The workbook is stored in a public folder.  

After the AutoOpen macro navigated to the Sheet with the Calendar Controls, the user could not update the dates.  The user had no control over the Calendar.

What can I do to update the user's privileges in Excel to allow the use of this control?

Thank you

Glen
GPSPOWAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Can you attach the workbook?
0
GPSPOWAuthor Commented:
Attached is the file.  You will not be able to envoke the command button to update the data after you selec the dates.

Thanks

Glen
IPA-Staff-Review.xlsm
0
Martin LissOlder than dirtCommented:
Not at home now but will look at it in the AM.
0
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Glenn RayExcel VBA DeveloperCommented:
I'm using Excel 2010 and could not use the calendar controls because the Microsoft Calendar Control library file is missing from my computer:
References - calendar control missing
You'll have to find a copy of that file (MSCAL.OCX), add it to your user's computer, register it (using REGSVR32.EXE) before that user can run the workbook.

-Glenn
0
GPSPOWAuthor Commented:
Can I change the object to a Text Box with a format of Short Date?  Or is that only in a Ms-Access form?

Glen
0
Martin LissOlder than dirtCommented:
It works for me. Is it just one user having the problem?
0
GPSPOWAuthor Commented:
I only tested it on one desktop.  There could be more users

Glen
0
Martin LissOlder than dirtCommented:
If you create a new workbook with a calendar control, what happens?

BTW are you aware that while you can often get away with using ActiveX controls on a sheet, that they are not designed to work there? A better approach might be to show a userform that contains the calendar controls.
0
jkpieterseCommented:
Martin: Placing the calendar control on a userform will not fix the missing reference problem. Using a method like this will avoid the problem alltogether:

https://sites.google.com/site/e90e50/calendar-control-class
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GPSPOWAuthor Commented:
That is the solution I found

Thanks

Glen
0
jkpieterseCommented:
You're welcome!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.