Agent skill · Audited from source
Excel Vba Duplicate Prevention For Composite Keys Columns A And
skill · ECNU-ICALK/AutoSkillLicence not declaredAudited 14 Oct 2026 · source 04e912cff54b
Is it safe? Yes — SAFE, grade B (89/100). We read this skill's source at commit 04e912cff54b and found no filesystem, network or shell access and no hard-coded secrets. What it does: Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and…
Cite
Cite this page
ModelsAtlas. “Excel Vba Duplicate Prevention For Composite Keys Columns A And (ECNU-ICALK/AutoSkill)”. Retrieved 14 Oct 2026. https://modelsatlas.com/skills/ecnu-icalk/excel-vba-duplicate-prevention-for-composite-keys-columns-a-and
Trust audit
Audit 0.4.1 · source read 14 Oct 2026
SAFE means nothing in the source contradicts what the skill says it does. Grade B is shared by 16,667 of 17,602 audited skills.
What the source does
- FilesystemNone observedNo reads or writes in the source
- NetworkNone observedNo outbound calls in the source
- ShellNone observedNo commands run in the source
- DependenciesPinnedNothing floats
- SecretsNone foundNo keys in source
Five audit layers
| Layer | What we check | Result | Findings |
|---|---|---|---|
L0 Provenance | Repo owner, licence, archive status, activity | PASS | 0 |
L1 Static source | Secrets, path traversal, supply chain, hidden code | NA | 0 |
L2 Instructions | Prompt injection, authority framing, hidden directives | PASS | 0 |
L3 Inventory | The files and declarations match the source | PASS | 0 |
L4 Sandbox | Run in isolation and watch behaviour | SKIPPED why | 0 |
Gates applied: no behavioural pass.
Findings (0)
No findings at any severity. We re-audit when the source changes.
Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan
Provenance
Who published it, and what the verdict is pinned to
- PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
- Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-duplicate-prevention-for-composite-keys-columns-a-and-The exact folder we audited
- LicenceNot declaredAs the repository states it
- Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
- Repository statusNot archivedLast push 157 days ago
- Sandboxed runNot runSkills are read, not executed; layer L4 is skipped
What it tells the agent
Full source on GitHub ↗Its description: Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and…
--- id: "06a3c9bb-862b-4965-b19b-59391d1374f1" name: "Excel VBA Duplicate Prevention for Composite Keys (Columns A and D)" description: "Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and clears the new value in Column D." version: "0.1.0" tags: - "Excel" - "VBA" - "Duplicate Prevention" - "Data Integrity" - "Macro" triggers: - "excel vba prevent duplicate column a and d" - "vba macro check duplicate two columns" - "excel composite key duplicate warning" - "clear entry if duplicate in column a and d" --- # Excel VBA Duplicate Prevention for Composite Keys (Columns A and D) Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and clears the new value in Column D. ## Prompt # Role & Objective You are an Excel VBA expert. Your task is to write a Worksheet_Change macro that prevents duplicate entries based on a composite key consisting of Column A and Column D. # Operational Rules & Constraints 1. **Trigger**: The macro must execute automatically when a user enters or modifies a value in Column D. 2. **Duplicate Logic**: Check if the combination of the value in Column A and the value in Column D of the active row matches the combination in any other row in the worksheet. 3. **Warning Message**: If a duplicate is found, display a pop-up message (MsgBox) indicating the specific row address where the duplicate entry exists. 4. **Correction Action**: If a duplicate is found, clear the contents of the new entry in Column D only. Do not clear Column A or other columns. 5. **Data Context**: Assume the user enters data in columns A, B, C, and D. Columns A and D are the critical fields for the duplicate check. # Anti-Patterns - Do not use Data Validation formulas; use VBA. - Do not ask the user for confirmation (Yes/No); simply warn and clear the value in Column D as per the final requirement. - Do not clear the entire row; only clear the cell in Column D. ## Triggers - excel vba prevent duplicate column a and d - vba macro check duplicate two columns - excel composite key duplicate warning - clear entry if duplicate in column a and d
Excerpt, first 2,415 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.
Install
Pinned to the audited commit 04e912c
git clone https://github.com/ECNU-ICALK/AutoSkill git -C AutoSkill checkout 04e912cff54b
The author documents no install command, so this uses the repository directly. Our verdict covers commit 04e912cff54b only.
Works in
The author has not said which agents this skill supports, and we have not tested it in any.
Audit history
Every audit, every source change
- ✓SAFE B 89 / 100
first audit · source
04e912cff54b
Similar skills
All data & analysis skills →ECNU-ICALK/AutoSkill
Executes a 1-back test by comparing the current input to the immediately preceding input in a sequence, reporting the prior item and a match indicator.
ECNU-ICALK/AutoSkill
Identifies the critical 20% of a given topic that yields 80% of the results and creates a focused learning plan to master it.
ECNU-ICALK/AutoSkill
Act as a friendly English teacher for A1 students. Correct errors briefly, ask clarifying questions to maintain dialogue, and strictly limit responses to 100 words.
ECNU-ICALK/AutoSkill
运用理性情绪疗法ABC模型,按客观事实→情绪反应→自动想法→合理/不合理区分四步顺序,引导来访者辨析创伤相关歪曲信念,并通过挑战式提问促发认知重评。
ECNU-ICALK/AutoSkill
Generates academic content components (introductions, conclusions, titles, topics) and full expository essays. Includes specialized capabilities for refining research paper titles with specific constraints, emphasis,…
ECNU-ICALK/AutoSkill
Draft or improve emails to professors using simple vocabulary, friendly tone, and straightforward grammar.
Questions about Excel Vba Duplicate Prevention For Composite Keys Columns A And
What does the Excel Vba Duplicate Prevention For Composite Keys Columns A And skill do?
Is Excel Vba Duplicate Prevention For Composite Keys Columns A And safe to install?
What can Excel Vba Duplicate Prevention For Composite Keys Columns A And access on my machine?
How current is this page?
Sources
- github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026
Spotted something wrong? Report a correction · Methodology
Keep going in your AI
Opens with this page as the source. We add nothing else to the prompt.
- What does the Excel Vba Duplicate Prevention For Composite Keys Columns A And skill do?
- Is Excel Vba Duplicate Prevention For Composite Keys Columns A And safe to install?
- What can Excel Vba Duplicate Prevention For Composite Keys Columns A And access on my machine?