How to Fix Can't Find Project or Library Error

Problem:

When using the VBA Code or Macros in Microsoft Access or Excel, the following errror is received “Compile Error: Can’t find project or library”

Solution(s):

Step 1. Open the MS Excel file, giving an error message.

Step 2. Press “ALT and F11 keys”, for VB Editor in a new window (as below).

Step 3. Click on Reset button

Step 4. Click on Tools menu and then select References from pulled down menu, as shown

Step 5. Following dialog box will display uncheck ‘Missing object library or type’ ,==> OK

Step 6. Exit and save the original Excel file.

DONE