ODF spreadsheet with VBA macros

[dinoap]

Good afternoon everyone. My first post and I really need some help if you can. I’m not savvy at all with macros or Visual Basic. I have a LibreOffice

Calc sheet that will run the VBA as it should all day long until I save the worksheet and re-open. Once I re-open the sheet the only way to get the macro / VBA to run is to manually select it and run it. Then it only runs once. I bought the file online (I don’t have the knowledge) and it was made for Excel but I don’t have a Microsoft license. It was working perfectly as written…until saved and re-opened.

I will try to attach the workbook here. If someone could give it a look and help me find a way so the Macro or VBA runs at all times while the sheet is open I would greatly appreciate it. Thank you in advance.

The VBA is called “Module2” but don’t quote me on that.

665 Inventory Latest.ods (33.1 KB)

Chris

[fpy]

@dinoap

run

doin what ?

@dinoap

online

where from ?

This is the guide - How to use the Ask site? - #3 by Hrbrgr

[dinoap]

On scan tab you’ll see a “Quanity box” and a “barcode box”
Normally when you enter a quanity in the QTY box and then scan the barcode of the item into the barcode box the qty of the item is added to the inventory tab automatically.
When the sheet stops working… the barcode itselff stays in the barcode box instead of clearing itself and adding to the inventory.