home/categories/ide-plugins/ecnu-icalk-autoskill-skillbank-convskill-english-gpt4-8-excel-vba-selection-change-row-hiding-and-coloring-skill-md
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.

ECNU-ICALK
maintainer
ECNU-ICALK
更新於 3/16/2026
星標
304
分支
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.

安裝
$ install --globalskills.sh
使用

安裝後,您可以透過在終端機執行以下指令來使用此技能:

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