Link to home
Start Free TrialLog in
Avatar of GPSPOW
GPSPOWFlag for United States of America

asked on

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Can you attach the workbook?
Avatar of GPSPOW

ASKER

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
Not at home now but will look at it in the AM.
I'm using Excel 2010 and could not use the calendar controls because the Microsoft Calendar Control library file is missing from my computer:
User generated image
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
Avatar of GPSPOW

ASKER

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
It works for me. Is it just one user having the problem?
Avatar of GPSPOW

ASKER

I only tested it on one desktop.  There could be more users

Glen
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.
ASKER CERTIFIED SOLUTION
Avatar of Jan Karel Pieterse
Jan Karel Pieterse
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GPSPOW

ASKER

That is the solution I found

Thanks

Glen
You're welcome!