EdwardNavarro/barcode-vba-macro-only

QR bar-codes - redrawing - slowing taking all Excel resources while scrolling

Opened this issue · 1 comments

What steps will reproduce the problem?
1. Create like 6,7 QR bar-codes as a graphic
2. Try scroll the screen
3. Bar codes are being re-drawn, processor usage raises ~20%, excel is 
unavailable until calculation has finished 

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
Windows 7, Ms Excel Pro 2013

Please provide any additional information below.
Function I use is:
=EncodeBarcode(CELL("SHEET"),CELL("ADDRESS"),A1&CHAR(9)&'DXN1'!E2,51,1,3)

Original issue reported on code.google.com by pio2...@gmail.com on 8 Jan 2015 at 2:45

I've notices that if barcodes is displayed in non-complessed format like BMP 
redrawing does not take a place. Just do not know how to amend that in the 
macro. 

Original comment by pio2...@gmail.com on 8 Jan 2015 at 3:02