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
์—…๋ฐ์ดํŠธ๋จ 2026. 3. 16.
์Šคํƒ€
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