Forum Discussion
Misha_Zainab100
Jan 19, 2022Copper Contributor
Checkbox to move with sort
Hi I am looking to use a checkbox as a entity in cell and not an object so that when I filter my columns my checkbox option also move for example in below only B2 and D4 is ticked and when I want to ...
Misha_Zainab100
Jan 19, 2022Copper Contributor
Thank you NikolinoDE, I want the checkbox to move with the cell but keep the order and I noticed my option for move and size with cell is disabled (greyed out) ;(
Misha_Zainab100
Jan 19, 2022Copper Contributor
- NikolinoDEJan 19, 2022Platinum ContributorI am glad that you can make progress in your project.
I wish you much success and fun with Excel.- Misha_Zainab100Jan 19, 2022Copper ContributorOne last think how do I lock it so no one can change it after I have ticked the right boxes?
- NikolinoDEJan 19, 2022Platinum Contributor
You may want to add protection to Form controls and ActiveX controls to prevent users from moving, changing, or deleting controls.
Protect controls and linked cells on a worksheet
- Misha_Zainab100Jan 19, 2022Copper ContributorThank you 🙂