To do this you use the File, Options command again. If the referenced file is in a new location, clear the “Missing:” reference and create a new reference to the file in its new location. This isnt quite enough because you also have to allow the Excel to run programs included with spreadsheets. If you are using COM, ActiveX, or a DLL to format data to a barcode font, use the pure VBA code that is provided in the licensed version of the product.Īn alternative to removing the reference is to restore the referenced file to the path specified in the References dialog box.on some monitor screens may not show as significantly different from black.

Clear the check box for the type library or object library marked as “Missing:” You do this, in the VBA editor, with the command sequence Run Reset or.Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.Most likely, the application has lost the reference to an ActiveX or COM object or type library resulting in the above error when using VBA functions in Access or Excel such as the Barcode Font Encoder VBA. When using the VBA Code or Macros in Microsoft Access or Excel, the following error is received “Compile Error: Can’t find project or library” Solution(s):

Visual basic for excel not showing