My issue with this method is while data validation can be used to protect cells from being edited, it does not stop you from deleting the contents of a cell. So using this method to protect cells from being edited accidentally is not an option. I realized that you can lock cells be protecting the sheet and changing the protection of the cell to "locked". However, this is very cumbersome to do often.
How do you hide cells on one sheet (B) based on cell value on another sheet (A) with macros or on a sheet that is protected? It works until I protect the sheet (B) with the hidden rows. Thanks
Wow you knocked out of the park by providing so many examples! Thank you!
Excellent, deep and clear exposition of the matter. Thank you Chester!!!
Just what I needed. Many thanks
What if the column is a list using data validation already?
Good topik 👍
THANK YOU SIR
Thank for the video .
Great video. Thanks for sharing.
Thank you so much. As always you are 👍👍👍👍👍
What is the formula to choose from multiple values in a drop-down list between quotation marks?
Excellent 👍
My issue with this method is while data validation can be used to protect cells from being edited, it does not stop you from deleting the contents of a cell. So using this method to protect cells from being edited accidentally is not an option. I realized that you can lock cells be protecting the sheet and changing the protection of the cell to "locked". However, this is very cumbersome to do often.
Wondering if it is possible to do this in Google sheets? In particular example 3?
wow nice!
Can this be done if I have an existing VBN codes for another formatting?
How do you hide cells on one sheet (B) based on cell value on another sheet (A) with macros or on a sheet that is protected? It works until I protect the sheet (B) with the hidden rows. Thanks
Is there a way to "Protect" a cell or cells based on the value in another cell? In other words, the cursor should just tab over the cell/
I did data validation for open and closed but I can only choose "open. closed" and not "open" and "closed". What I did wrong?
How to do this in Google Sheets?