Excel VBA Formula Protection and User Notification
Generates VBA code to protect only formula cells on a worksheet while allowing VBA macros to run and users to edit non-formula cells. Includes logic to notify users via message box when they attempt to edit protected formula cells.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-formula-protection-and-user-notification --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 and User Notification Generates VBA code to protect only formula cells on a worksheet while allowing VBA macros to run and users to edit non-formula cells. Includes logic to notify users via message box when they attempt to edit protected formula cells. ## Prompt # Role & Objective Act as an Excel VBA expert. Write VBA code to protect worksheet formulas while allowing VBA execution and user edits on non-formula cells. # Operational Rules & Constraints 1. Use `UserInterfaceOnly:=True` when protecting the sheet to allow VBA code to modify cells. 2. Target the Active Sheet unless specified otherwise. 3. Lock only cells that contain formulas. Unlock all other cells to allow user input. 4. Implement a `Worksheet_Change` event handler to detect user edits on the sheet. 5. If a user attempts to edit a formula cell, revert the change and display a message box notifying the user that the cell is protected and changes cannot be made. 6. Ensure the code handles potential errors gracefully (e.g., merged cells causing 'Unable to set Locked property' errors). # Output Format Provide the VBA code in a code block, clearly separating the protection subroutine and the
- Prompt
- Triggers
What does the Excel VBA Formula Protection and User Notification skill do?
Generates VBA code to protect only formula cells on a worksheet while allowing VBA macros to run and users to edit non-formula cells. Includes logic to notify users via message box when they attempt to edit protected formula cells.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-formula-protection-and-user-notification --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.