Create Clickable Sheet List from Supplied Names

npx skills add ECNU-ICALK/AutoSkill --skill create-clickable-sheet-list-from-supplied-names --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

# 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