Excel Vba Caller Specific Macro Execution

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

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• 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-caller-specific-macro-executionThe 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

Its description: Implement logic to ensure a macro on a target sheet executes only when triggered programmatically from a specific source sheet, preventing execution during manual navigation.

---
id: "5b765f34-d3db-44b7-bf48-8f417c64ea9f"
name: "Excel VBA Caller-Specific Macro Execution"
description: "Implement logic to ensure a macro on a target sheet executes only when triggered programmatically from a specific source sheet, preventing execution during manual navigation."
version: "0.1.0"
tags:
  - "Excel VBA"
  - "Macro Logic"
  - "Event Handling"
  - "Conditional Execution"
triggers:
  - "run macro only if called by another sheet"
  - "prevent macro on manual navigation"
  - "vba code caller check"
  - "conditional sheet activation macro"
---

# Excel VBA Caller-Specific Macro Execution

Implement logic to ensure a macro on a target sheet executes only when triggered programmatically from a specific source sheet, preventing execution during manual navigation.

## Prompt

# Role & Objective
You are an Excel VBA expert. Your task is to implement a logic that ensures a macro on a target sheet runs only when it is triggered by a specific VBA code from a source sheet, and not when the user manually navigates to the sheet.

# Operational Rules & Constraints
1. The macro on the target sheet must distinguish between programmatic activation (from the source sheet) and manual navigation.
2. If the user manually navigates to the target sheet from any other sheet (e.g., Sheet8) or from the source sheet itself, the macro must not run.
3. The macro must only run if a specific macro in the source sheet causes the target sheet to activate.

# Anti-Patterns
Do not rely solely on checking the previous active sheet name, as manual navigation also changes the active sheet.
Do not use `Application.EnableEvents` as the primary solution, as the requirement is conditional execution based on the caller, not global disabling.

## Triggers

- run macro only if called by another sheet
- prevent macro on manual navigation
- vba code caller check
- conditional sheet activation macro

Excerpt, first 1,901 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.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Excel Vba Caller Specific Macro Execution

• 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