Rejected

Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Bullets

Command ID: btnXCheckbox

What it does

Prepends a crossed checkbox ☒ plus a space to every line inside the selected cells. This is the third state of the checkbox set, for items that failed, were rejected, or do not apply: a check point that failed inspection, material turned away at goods-in, or an N/A line in an ITP.

The command strips any existing symbol before inserting, so moving a row from ☐ or ☑ to ☒ takes one click.

How to use

1. Select the cells for the items that failed or are not applicable.
2. Go to the DVD Addin tab → Text and Number group → open the Bullets menu → choose Rejected.
3. The add-in strips the previous symbol, then handles each cell:
   • Text cell — each line is trimmed, then ☒ is added at the start.
   • Empty cell — just ☒ is written.
   • Formula cell — wrapped as =""&"☒ "&(original formula), so the symbol shows while the formula stays live.
4. The status bar reports Processed N cells (checkbox ☒).

Example

The goods-in inspection record for a rebar delivery received on 12 August:

Before	After (two failed items marked)
☑ CO/CQ quality certificates complete	☑ CO/CQ quality certificates complete
☑ Marking and diameter match the order	☑ Marking and diameter match the order
☐ Surface free of rust and distortion	☒ Surface free of rust and distortion
☐ Tensile test results within tolerance	☒ Tensile test results within tolerance

The two ☒ lines are exactly what the corrective-action request to the supplier is built on.

Notes

• The command applies ☒ to every cell in the selection, so select only the rows that actually failed.
• The symbol is a character in the cell text, not a clickable control, and it is not linked to any TRUE/FALSE cell.
• Each line is trimmed of surrounding whitespace before the symbol is added.
• Cells holding numbers, dates, or TRUE/FALSE are skipped, and Ctrl+Z will not undo the change.
• Hidden rows and columns are skipped, and each merged area is processed once, at its top-left cell.

Related

• Checkbox — the starting state, an empty box awaiting inspection.
• Checked — the pass state, for completed items.
• (None) — strip every symbol from the selection.
• Filled star — highlight items that still need follow-up after the rejection.