Barcode macros do not run, files do not open or #NAME error is displayed

< Back
You are here:
Print

Barcode macros do not run, files do not open or #NAME error is displayed

Solution(s):

When using Barcode Macros and VBA for Microsoft Office or ActiveX Barcode Controls in a barcode field with Office XP, 2000 & 2003, one of the following may occur:

  • A macro in Excel may return #NAME in the field that is supposed to represent a barcode.
  • The file may open without any warnings and the barcode may not be displayed.
  • Security settings may restrict access to the file, so that it will not open.
    file digitally signed image

Usually this is due to the Microsoft Office security level being set at HIGH, thus preventing any macros from running or ActiveX Controls from being used. This can be resolved by performing the following:

  1. In the application,  choose Tools – Macro – Security and set the security level to medium.
    Tools – Macro – Security
  2. Save and close the document.
  3. Reopen the document and choose “enable macros” when prompted.

To avoid these errors in a solution that is distributed, IDAutomation suggests signing the files and macros in the solution.

Previous ActiveX Controls, Office Add-in or VBA Macros incompatible with Office 2010 64-bit
Next Compile Error: Can’t find project or library
Table of Contents