Cells required before close

[RattlingCarp3048]

I have a shared workbook that anyone can add data to. The user will open the workbook and add data to the next available row. Column A is always filled in 100% when they add data. If data is entered into column A, then columns B-J are required. Problem is...users are constantly leaving some portion of B-J empty and i am having to remind them or go behind them to fill in the information and that is just waaaaayyyy too much upkeep for one person. I suspect VBA would be the best way to go about this but im open to other options. The actual text itself doesnt matter.

Can someone help with a way to prevent the workbook from being closed if column A is not blank and any cell on that row between B-J is blank then the workbook will not close? Bonus points for an error message that tells the user which cell they left blank.

Any and all help appreciated

free text	dropdown list	dropdown list	date	date	formula	dropdown list	free text	dropdown list	dropdown list
apple	1	single	1/17/2025	1/17/2025	mmmm	paid	granny smith	yes	no	a=not blank and B-J are completed = close workbook
banana	3	bundles	1/17/2025	1/17/2025	mmmm	paid		yes	yes	a=not blank and no data in H = workbook will not close
grape	1	packages	1/17/2025	1/17/2025	mmmm		package of red grapes	no	yes	a=not blank and no data in G = workbook will not close
kiwi	4		1/17/2025	1/17/2025	mmmm	pending	yellow kiwi's	no	no	a=not blank and no data in C = workbook will not close
										a=blank = close workbook