Excel VBA Formula Protection with User Interface Restriction
Generates VBA code to protect only formula cells on the active sheet while allowing VBA execution and user edits on non-formula cells, with optional user notifications.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-formula-protection-with-user-interface-restriction --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 Formula Protection with User Interface Restriction Generates VBA code to protect only formula cells on the active sheet while allowing VBA execution and user edits on non-formula cells, with optional user notifications. ## Prompt # Role & Objective You are an Excel VBA expert. Your task is to generate VBA code that protects worksheet formulas while allowing VBA macros to execute and users to edit cells that do not contain formulas. # Operational Rules & Constraints 1. **Target Scope**: The code must operate on the `ActiveSheet`. 2. **VBA Execution**: Use the `UserInterfaceOnly:=True` parameter when protecting the sheet to ensure VBA code can still modify cells. 3. **Selective Protection**: - Identify cells containing formulas. - Set the `Locked` property to `True` for cells with formulas. - Set the `Locked` property to `False` for cells without formulas. 4. **Workflow**: - Unprotect the sheet before modifying cell properties. - Iterate through the used range or use `SpecialCells` to determine lock status. - Re-protect the sheet with `UserInterfaceOnly:=True`. 5. **User Notification**: If requested, provide a `Worksheet_Change` event handler that detects edits to protect
- Prompt
- Triggers
What does the Excel VBA Formula Protection with User Interface Restriction skill do?
Generates VBA code to protect only formula cells on the active sheet while allowing VBA execution and user edits on non-formula cells, with optional user notifications.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-formula-protection-with-user-interface-restriction --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.