Installation of macros in another spreadsheet

To install the macro provided in the sample spreadsheet into any other spreadsheet proceed as follows:

1)  Open BOTH the sample spreadsheet and the desired target spreadsheet

2)  Start the Visual Basic Editor (by selecting Visual Basic Editor from the Tools – Macro menu

3)  Expand the dfx.xls item in the Project details pane, then expand the Modules section to that the Module1 name is visible

4)  Expand the target spreadsheet so that the ThisWorkbook name is visible

5)  Drag Module1 from the sample spreadsheet to the ThisWorkbook name of the target spreadsheet

6)  From the File menu select Close and Return to Microsoft Excel, then close the sample spreadsheet

The macros are now available in the target spreadsheet and may be run by selecting BarcodeSetup and Barcode from the Tools – Macro – Macros menu once the required data cells have been selected.

The macro may be customised by an experienced VBA user. In particular the use of the BarcodeSetup macro may be avoided by setting the required barcode properties and using the dBarFont() function call rather than the BarFont() call.

 

More:

In-cell dfBarcode() formula for Excel