jooviertsmitch

New Member
Joined
Mar 23, 2019
Messages
2
Hi all. I recently made an excel VBA project which then turned out to be a huge application. This application is being saved in a network shared folder where multiple users are able to access the file (only one at a time though).

So, this application runs smoothly thus far on multiple machine. However, a compile error stating "Object library invalid or contains certain references to object definitions that could not be found" showed up when opened by a third user.

The example scenario1: File developed by me, User B opened file, modified and saved, User C tries to open file but encountered the compile error.
On a same scenario as scenario1 but instead of User B, User D opened file, modified and saved, User C has no issues opening and continue modifying the file. All users have the same references as well.

All users have windows 10 and Excel 2013. User B, D and I have VBA 7.1.1056 while user C has VBA 7.1.1049.

The compile error would highlight this particular section: "Private Sub Worksheet_Activate" from the below code in sheet 10
Code:
Private Sub Worksheet_Activate()    
    ThisWorkbook.Sheets("Sheet10").Shapes("ListBox1").Width = 500
    ThisWorkbook.Sheets("Sheet10").Shapes("ListBox1").Height = 100
End Sub

Really appreciate your help and input.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
3,019
Check to make sure everyone has the same screen resolution and dpi settings. Frustrating background things that aren't obvious make me screen. :) Dave
 

jooviertsmitch

New Member
Joined
Mar 23, 2019
Messages
2
Hi Dave, thank you for your reply.

I've checked, all three users have the same screen resolution and dpi settings.

I really hope this can be resolved. This project would be the first I'm encountering such issues.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,775
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
My guess would be that one of you has a different update to the forms library so your activex controls are causing problems. If possible, I'd suggest rebuilding with Form controls (not the same as MSFORMS). If not, you'll need to make sure you all have the same updates.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,718
Messages
5,833,292
Members
430,203
Latest member
rmlnlo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top