masud8956
Board Regular
- Joined
- Oct 22, 2016
- Messages
- 163
- Office Version
- 2016
- 2011
- 2007
- Platform
- Windows
Hi,
I have 60 check boxs in 60 consecutive rows (same column) in 12 sheets of my workbook.
The 60 check boxs are linked to individual cells (2 columns to the right). Is there any way that I add a 61st (master!) check box which will be linked to rest 60, so I can check/uncheck all 60 just by clicking the 61st? And when I keep it unchecked, all 60 check boxs show individual selections.
I saw some solutions of similar kind using VBA. But I do not prefer VBA solution. Is there any other way to do it?
Regards!
I have 60 check boxs in 60 consecutive rows (same column) in 12 sheets of my workbook.
The 60 check boxs are linked to individual cells (2 columns to the right). Is there any way that I add a 61st (master!) check box which will be linked to rest 60, so I can check/uncheck all 60 just by clicking the 61st? And when I keep it unchecked, all 60 check boxs show individual selections.
I saw some solutions of similar kind using VBA. But I do not prefer VBA solution. Is there any other way to do it?
Regards!
Last edited: