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.