Excel VBA Formula Protection with User Interface Restriction — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel VBA Formula Protection with User Interface Restriction (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
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.
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.
ActiveSheet.UserInterfaceOnly:=True parameter when protecting the sheet to ensure VBA code can still modify cells.Locked property to True for cells with formulas.Locked property to False for cells without formulas.SpecialCells to determine lock status.UserInterfaceOnly:=True.Worksheet_Change event handler that detects edits to protected formula cells, reverts the change, and displays a message box notifying the user that the cell is protected.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.