Using Macro Button to Change Print Area & Print out

[nathanthomson11]

Good morning, I have a tracking file which automatically creates a new barcode each time a new line item is added. The barcodes are created in column 'BE' using the '3 of 9 Barcode' font. Beside each barcode in column 'BD' is a 'Print' button which I would like to be able to click and it will only print the barcode directly to the right. For example, someone enters a new line item on line 3456 a barcode is automatically created on 'BD3456 and a button exists on 'BE3456 which when pressed, would automatically change the print area to 'BD3456 and print the barcode.

 

[FracinDean]

I'm not sure how to do it with the button, but here is another option to think about.

After you generate the bar code, just use the same procedure to write the word "PRINT" in the cell to the right, in this case cell BE3456. Use the Worksheet_Change event procedure to check to see if the target cell contains the word "PRINT", and if so, then change the print range to the single cell one cell to the left.