Excel FAQ

I cannot change the barcode once I have closed the document.Link
I created a document with the barcode object, saved it and then closed it. The next time I open it, I cannot change the barcode object.
This has something to do with the security settings of your Office, Excel, Access or Word installation.
The ActiveX component is blocked by the security settings when opening the file.
You can change this by openning the document from a trusted location:

1. Click the Microsoft Office Button and then click on the Options button.
2. Click Trust Center, click Trust Center Settings, and then click Trusted Location.
3. Add the path of your document file to the trusted locations.
Barcode not modifiable?Link
Why can't I change the barcode, move it or resize it?
To be able to edit the barcode object, you must activate the design mode.
Use this button to switch to design mode:
Design mode
Then you'll be able to change the barcode by clicking the barcode with the right mouse button.
Adding a barcode object with a VBA macroLink
How to place a barcode automatically in a document using a VBA macro?
We have an extensive documentation to show how to use the barcode object with VBA..
Change the barcode text with a VBA macroLink
How can change the text of the barcode with a VBA macro?
Use the following command to change the text of a barcode:
ActiveDocument.Barcode1.Text = "12345"
We have an extensive documentation to show how to use the barcode object with VBA..
Barcode in a cellLink
How to place the barcode into a cell.
Excel cannont place a object into a cell. However, you can position the barcode object exactly over a cell, which has the same effect. You can do this manually, using the Add-In or use a macro:
  ' get cell size
MyHeight = Range(CurrentCell).Height
MyWidth = Range(CurrentCell).Width
MyTop = Range(CurrentCell).Top
MyLeft = Range(CurrentCell).Left

' extend cell height to 30px, change if you like
Range(CurrentCell).RowHeight = 30

' embed the control at the cell location
ActiveSheet.OLEObjects.Add(ClassType:="ACTIVEBARCODE.BarcodeCtrl.1", Link:=False _
, DisplayAsIcon:=False, Width:=MyWidth, Height:=30, Top:=MyTop, Left:=MyLeft).Select
We have an extensive documentation to show how to use the barcode object with VBA..
Entering control codes in ExcelLink
How to enter control codes, e.g. Return when using Excel with the barcode object?
Using the barcode object, you can capture control codes directly by the corresponding ASCII character.
So, you can create that character directly in Excel. To do this, use the function CHAR() [DE: ZEICHEN()] within a cell.
To map a Return (ASCII 13) the cell content might look like this:
="Any kind of Text"&CHAR(13)
Read on to find out more information on using control characters in barcodes.
Link a cell to the barcodeLink
How can I link a cell to the barcode object so that the barcode always encodes the value of that cell?
Open the Excel properties dialog for the barcode. In the properties dialog you can see the object name of the barcode object. Below that are the properties of the object with the property "LinkedCell", which allows linking the barcode with the content of a cell.
Enter the desired cell here (e.g. Z3S17, which corresponds to row 3, column 17).
Now the barcode is linked to the content of this cell: If this cell content changes, the barcode is automatically updated.

Hint: Use the Add-In to achieve this more easily.
Date as barcodeLink
How can I get a date in the form 05/19/08 (DD.MM.YYYY) displayed in the barcode instead of the number 39587?
If you enter the date directly into a cell, enter the following formula:
="19.05.08"
If the date is the result of a calculation, use use the following formula into another cell and link the barcode object to that cell:
=TEXT(B9;"TT.MM.JJJJ)"
B9 is the reference cell for the date and you must adapt it accordingly.
Security warning when opening Office 2003 documentsLink
I get security messages when opening Word or Excel documents under office 2003. How can this be avoided without lowering the security level?
Unfortunately, there is no such elegant solution for Office 2003 as for later versions with trusted locations. Nevertheless, it is possible to stop the query in general for ActiveX controls in Office 2003, by inserting a key into the Windows Registry. Note, that this solution is not only for ActiveBarcode but for all ActiveX controls.
The registry entry reads:

[HKEY_CURRENT_USER\Software\Microsoft\Office\Common\Security]
"UFIControls"=dword:00000001

We recommend to perform a backup before you change the registry.