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.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-caller-specific-macro-execution --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 o
- Prompt
- Triggers
What does the Excel VBA Caller-Specific Macro Execution skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-caller-specific-macro-execution --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.