Using the macros in Excel

PBarcodeSetup or FBarcodeSetup must be run at least once before the PBarcode and FBarcode macros can be used.

Whenever you wish to create a single barcode simply click the cursor in the cell containing the text you need to turn into a barcode, then run one of the Barcode macros from the list of macros in the Macros dialog.

If you wish to make barcode images from the data in several cells or an entire column, select the cells required or push the column button at the top of the column, then choose the required Barcode macro.

After the PBarcode macro has run the spreadsheet contains pictures super-imposed over cells. The pictures cannot be selected by clicking on a column header. However, the macro SelectPictures allows all pictures on the spreadsheet to be selected simultaneously, and the macro DeletePictures allows them all to be deleted. Note that these two macros affect all pictures on the spreadsheet – so if there are images other than barcodes created with PBarcode those image will be selected or deleted as well.

If you use the Barcode macros frequently you may wish to create a key shortcut for the macros concerned. To do this select the required macro in the Macros dialog, then push the Options button. Enter the required shortcut key in the dialog box presented and push the OK button.

 Now whenever you select a cell and push the appropriate shortcut key the text in that cell will be replaced by a barcode.

More:

Customisation of the Excel macros