Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium



Posted on 2014-08-10
Medium Priority
Last Modified: 2014-08-26
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.
Question by:Rrave26
  • 2
LVL 36

Expert Comment

ID: 40251834
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?

Author Comment

ID: 40251991
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
LVL 24

Accepted Solution

Steve earned 2000 total points
ID: 40252969
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 :)

Author Closing Comment

ID: 40286110
Ok, I have done this grade twice now hopefully you will get this today.

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question