excel

Good Morning,  I have a spreadsheet, Production IM Metrics, where initially I was just going to be using so I needed a calendar control date picker box which I had installed.  After I created this other users wanted to access this database, instead of installing this calendar controll many times, which my IT folks weren't happy about doing, I used some VB scripting, and help from other folks on this site, to create a calendar, located under Frms CalendarFRM.  This calendar is used to pick start and end dates for several reports that I run i.e., Weekly TTIIR and DQR report tabs.  The last part to this I believe, but not sure it's relevant, is that my company pays by usage licenses so effectively when I pull excel from a central location and check it out for use.      

Here is my issue:

My instance works fine but when another person opens the spreadsheet, navigates to either the DQR or the Weekly TTIIR worksheet tabs, clicks in cell J2, which is supposed to automatically bring up the calendar, they get a compile error:  Can't find project or library.  Now I have looked back in the developer tab under Tools/refrences to see if there are any missing references that need to be checked, but I do not see any.  How can I resolve this?  Any help or direction would be greatly appreceated.  

Oh Btw, I am a novice at VB and with much help have put this together but I am sure there is much improvement that can be done so I apologize upfront if it is cumbersome.
Prouduction-IM-METRICS-T-V03.xlsm
Rrave26Asked:
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.

NorieVBA ExpertCommented:
When are you looking under Tools>References...?

Is it when the other user has the workbook open or when you have it open?

Also, did you uncheck the reference for the calendar/date picker control after you'd added the new calendar you created?
0
Rrave26Author Commented:
I checked both.  My list has checked:

Visual Basic for Applications
Microsoft Excel 14.0 Objects Library
OLE Automation
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library
Ref Edit control
Microsoft Calenar Control 11.0 ( I can not uncheck this one as I am being told it is in use but I can't find where it is being used.) I suspect that this is the problem but don't knew how to find where it is being used.  However, my team mate doesn't have this one and keeps geeting that object or library can't be found message.

My teammates list has checked:
Visual Basic for Applications
Microsoft Excel 14.0 Objects Library
OLE Automation
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library
Ref Edit control
0
SteveCommented:
Just untick the callendar reference before you save the file?
That seems to do the job for me.

(i.e. Unticking the reference on the other machine, then saving before use)

I do not get an in use message though :)
U--Prouduction-IM-METRICS-T-V03.xlsm
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
Rrave26Author Commented:
Ok, I have done this grade twice now hopefully you will get this today.
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
VB Script

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.