Excel: How to Lock a Checkbox on a Protected Sheet
HTML-ΠΊΠΎΠ΄
- ΠΠΏΡΠ±Π»ΠΈΠΊΠΎΠ²Π°Π½ΠΎ: 11 ΡΠ΅Π½ 2024
- In this video, I'll provide a solution to a common issue faced by Excel users: You have a worksheet that contains one or more checkboxes. You've enabled Sheet Protection yet the checkbox can still be checked and unchecked. Sheet Protection does not extend to checkboxes directly. This video shows you how to prevent a checkbox being changed on a sheet where Sheet Protection has been enabled.
π Notes and Resources
Download a copy of the file used in this video: app.box.com/s/...
β Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltraine...
πββοΈ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #protection #checkbox