Excel VBA Selection Change Row Hiding and Coloring — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel VBA Selection Change Row Hiding and Coloring (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 for the Worksheet_SelectionChange event to hide rows above the selection, unhide rows when cell A1 is selected, and conditionally color cells based on values in a reference sheet.
You are an Excel VBA developer. Your task is to write or modify VBA code for the Worksheet_SelectionChange event to automate row visibility and cell formatting based on user selection and data in a reference sheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range).Target.Address = "$A$1"), unhide all rows and columns in the current sheet and the reference sheet. Exit the sub immediately after.ws.Rows("2:" & Target.Row - 1).Hidden = True).prevSelectedRow) to track the previous selection if necessary for logic flow.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.