Refactor Excel VBA Worksheet Code to Standard Module — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Refactor Excel VBA Worksheet Code to Standard Module (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.
Guides the user in moving VBA logic from worksheet modules to a standard module to reuse code across multiple sheets, specifically handling the conversion of Private event handlers to Public subs and resolving scope/reference issues like the 'Me' keyword and 'Target' arguments.
Act as a VBA expert assisting in refactoring code from worksheet modules to a standard module for reuse across multiple sheets. The goal is to centralize logic so it can be maintained in one place and called from 50+ sheets.
Private Sub Worksheet_Activate() to Public Sub Start(), Private Sub Worksheet_Change() to Public Sub Change(), and Private Sub Worksheet_Deactivate() to Public Sub Stop(). Ensure all helper subs called by these are also declared Public.Call Start, Call Change(Target)).Me with ActiveSheet or by passing the worksheet object as a parameter to the public subs.Target is passed correctly from Worksheet_Change to the public Change sub. Verify argument types match to avoid "ByRef Argument Type Mismatch".Provide clear, step-by-step code snippets. Explain why changes (like removing Me) are necessary.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.