We use cookies to provide you with the best experience and functionality on our website. By continuing to use the site, you are agreeing to our use of cookies.   

Excel 97, 2000, XP, 2003
Barcode objects in a spread sheet

Excel 97-2003

Embed and automate a barcode in a Excel 97, 2000, XP or 2003 document

A short description of how to add a barcode to your Excel sheet and link it with a cell: First launch Excel and create a new sheet or open an already existing sheet. Now go to the menu "Insert" and select "Object..." from that item list:

Barcode, Excel 97, 2000, XP, 2003


A dialog box appears:

Barcode, Excel 97, 2000, XP, 2003


Select "ActiveBarcode" now and click "Ok".

Alternatively you can use the function "More controls..." from the "Control Toolbox" of Excel to embed the control:

Barcode, Excel 97, 2000, XP, 2003


Now a barcode will be created inside your document. The embedded barcode will be a standard barcode of EAN-128 type. This is the default type. You can change this to any barcode type supported by ActiveBarcode: QR Code, GS1/EAN-128, Data Matrix, GTIN/EAN-13, Code 39, GS1-Data Matrix, Code 128, PDF417, DUN-14, EAN-8, EAN-14, EAN-18, ISBN, ITF-14, NVE, PZN8, SCC-14, SSCC-18, ...

Next switch to the "design mode" of Excel (e.g. use this button: Design Mode). Now you can modify this barcode. You can change the type, text, colors etc. For this click inside the barcode with the right mouse button. A pop up menu will open:

Barcode, Excel 97, 2000, XP, 2003


Select "ActiveBarcode-Object" and then "Properties...". The property dialog of ActiveBarcode will open. Here you can modify the barcode as you like.

Alternatively you can use the property dialog of Excel. For this use the following button names "Properties" in your symbol bar "Control-Toolbox":

Barcode, Excel 97, 2000, XP, 2003


Create a link between a cell and the barcode: Open the property dialog of Excel as described above. Now activate the barcode object by clicking onto it once. The property dialog will now display all the properties of the barcode object. Have a look for the property named "LinkedCell". This allows a link between a cell and the barcode:

Barcode, Excel 97, 2000, XP, 2003


Enter the cell's name for the link into this property. That's it!

This manual was created by Frank Horn

Search this site with Bing:
| Home | Shop | Download | E-Mail | Datenschutz | Imprint | Version 6.2.0 |
Web DesignszBubble
Web design & developement:

Frank HornActiveBarcode Generator App
Web design
Copyright Frank Horn
Lars SchenkActiveBarcode Object
Web- & server component
Command line
Copyright Lars Schenk

All trademarks and product names mentioned are the property of their respective owners.