If C3 cell contain "Finish" (from drop down list or formula),
then the total 3rd ROW must be HIDDEN (Note Filter) and protected with any fixed password. No need to enter password again and again, it should setup with one fixed password, which can be changeable if needed.
This formula will apply for entire SHEET not only for 3rd ROW
Last edited by rajeshn_in; 10-08-2016 at 12:56 PM.
"This formula will apply for entire SHEET not only for 3rd ROW " but the keyword HIDDEN is in Column C
- Battle without fear gives no glory - Just try
Thank you for your reply,
3rd ROW means total ROW A to END, Not only C
Yes clear but the HIDDEN selection is done in column C
Is it what you want
Overall see file attached
Please Login or Register to view this content.
Sorry, its not mean HIDDEN, its HIDE
if that particular row c column is "finish"
I want entire row hide and protect
If possible AUTO HIDE & PROTECT
Can any one please change D column is not >6, its a text "Finish", make it AUTOHIDE, no need to use any buttons or else.
Please Login or Register to view this content.
Last edited by rajeshn_in; 10-08-2016 at 05:40 PM.
Perhaps
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks