Scanning barcodes into excel

I am trying to scan bar codes from invoices and if there is a match highlight the cell yellow.
The code here works only on the active worksheet. Can this be adjusted to check all sheets in a workbook if its looking in the same column on all sheets? Also, if i scan a bar code and it matches it works perfectly. If i go back to cell A1 where i input my scan and delete the scan the next empty cell below my data highlights yellow. I assume this is because its matching the empty cell in A1 after i delete the scan? Can i prevent that?

Please Login or Register  to view this content.

Yes when i scan a barcode i would like it to match all worksheets in the book and highlight any matches yellow.

Thank you very much this worked like a charm.

If i may, I have one last tweak i have asked to do.
Currently the code below highlights one cell in column 2 that matches the scan on another sheet. I have been asked instead of matching just the cell and highlighting it can i make it highlight the whole row. In this case it would be for example row 3 columns b-k. Is that possible?
Here is the code

Please Login or Register  to view this content.

works perfectly. Thank you again!