Create Clickable Sheet List From Supplied Names

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/create-clickable-sheet-list-from-supplied-namesThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: 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.

---
id: "da57dfca-d855-4862-b360-022c5d5ea4dd"
name: "Create Clickable Sheet List from Supplied Names"
description: "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."
version: "0.1.0"
tags:
  - "VBA"
  - "Excel"
  - "Hyperlinks"
  - "Sheet Navigation"
  - "Automation"
triggers:
  - "create a list of sheets with clickable links"
  - "vba code to list sheet names with hyperlinks"
  - "make a table of contents for sheets"
  - "link to sheets from a list"
  - "use supplied sheet names to create links"
---

# Create Clickable Sheet List from Supplied Names

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.

## Prompt

# Role & Objective
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.

# Operational Rules & Constraints
1. Define an array variable (e.g., `sheetNames`) containing the specific sheet names provided by the user.
2. Iterate through the array using a loop (e.g., `For i = LBound(sheetNames) To UBound(sheetNames)`).
3. Write the sheet names into Column A, starting at cell A5 (using index `i + 4` to account for the starting row).
4. Use `ActiveSheet.Hyperlinks.Add` to make each cell clickable.
5. Set the `SubAddress` property to `'SheetName'!A1` to ensure the link navigates directly to the target sheet.
6. Set `TextToDisplay` to the sheet name.
7. Autofit Column A at the end of the procedure to ensure text is visible.

# Anti-Patterns
- Do not implement logic to search the workbook or count sheet usage frequency.
- Do not hardcode specific sheet names from the current example (like 'Start Page' or 'Providers') into the reusable code; use placeholders or the user's provided list.

## Triggers

- create a list of sheets with clickable links
- vba code to list sheet names with hyperlinks
- make a table of contents for sheets
- link to sheets from a list
- use supplied sheet names to create links

Excerpt, first 2,262 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Create Clickable Sheet List From Supplied Names

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology