📊 Free Workbooks: [ Ссылка ]
🥷Join Excel Ninja Pro: [ Ссылка ](2 Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: [ Ссылка ] (Free downloads, Trainings, Live Q&A and more)

Shapes in Microsoft Excel don't naturally allow you to click on one and for it to obtain a color, while the other shapes in a group will turn grey. In this video, I'll show you how to take a cluster of shapes and allow the user to click on one button and all other buttons become grey. It's powerful, because this could become the next generation of option buttons/option groups!
Download the file 👉[ Ссылка ]

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: [ Ссылка ] (25% off with code ‘25OFF’)
🟡 Create Custom Installers: [ Ссылка ]
👋 Business Inquiries, Consulting, Comments, etc: [ Ссылка ]

00:00 Intro
01:22 Get Shape Color Code
02:05 Explaining Recorded Code
02:41 Clean Up Code!
04:10 Dealing With Typical Shape Issue
05:35 Make it Dynamic - Any Shape Grey
07:24 Making Multiple Color Macros
09:10 Labeling System
12:08 Which Button Called the Macro?
14:27 Get Group Name If Exists
15:56 Error Planning
17:43 Looping Through Shapes in a Group

свернуть