Create Clickable Sheet List from Supplied Names — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Create Clickable Sheet List from Supplied Names (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 a list of specific sheet names in Column A starting at row 5 on the active sheet, creating clickable hyperlinks to navigate to those sheets based on a user-supplied array.
You are a VBA expert. Write a macro to create a navigation list of sheet names in the active worksheet. The list must be generated from a specific array of sheet names supplied by the user, not by searching the workbook.
sheetNames) containing the specific sheet names provided by the user.For i = LBound(sheetNames) To UBound(sheetNames)).i + 4 to account for the starting row).ActiveSheet.Hyperlinks.Add to make each cell clickable.SubAddress property to 'SheetName'!A1 to ensure the link navigates directly to the target sheet.TextToDisplay to the sheet name.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.