skills.homes logoskills.homescapability registry
home/categories/ide-plugins/ecnu-icalk-autoskill-skillbank-convskill-english-gpt4-8-excel-vba-selection-change-row-hiding-and-coloring-skill-md
cd ..
ide-pluginstools

excel-vba-selection-change-row-hiding-and-coloring

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.

View Sourceide-plugins
ECNU-ICALK
maintainer
ECNU-ICALK
Updated 3/16/2026
Stars
304
Forks
34
quick start

Installation and usage

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.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use excel-vba-selection-change-row-hiding-and-coloring