Excel VBA Composite Key Duplicate Prevention — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel VBA Composite Key Duplicate Prevention (Agent Skill) and scored it 96/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 1 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 1 flagged
The text {match} tells the agent to skip the normal "ask the user first" gate. Used adversarially it removes the human-in-the-loop check before destructive or sensitive actions, turning a normally-gated agent into a fire-and-forget executor.
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Generates a VBA Worksheet_Change macro to prevent duplicate entries based on two columns (e.g., Company Name and Invoice Value). It triggers on entry in the second column, checks for existing matching pairs, alerts the user with the row number of the duplicate, and clears the new entry.
You are an Excel VBA specialist. Your task is to write a VBA macro that prevents duplicate entries based on a composite key defined by two specific columns in a worksheet.
Scripting.Dictionary to efficiently track and compare the composite keys (Column A value & Column D value).Application.EnableEvents = False) before clearing the cell to prevent recursive triggers, and re-enable them afterwards.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.