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
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
Microsoft Excel
Last Comment
Jan Karel Pieterse
Can you attach the workbook?
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
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:
![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
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
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
Glen
It works for me. Is it just one user having the problem?
ASKER
I only tested it on one desktop. There could be more users
Glen
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.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That is the solution I found
Thanks
Glen
Thanks
Glen
You're welcome!