Results 1 to 8 of 8

If one cell contain certain word, then total row will be hide and protect

Threaded View

  1. 10-08-2016, 12:51 PM #1
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    701

    If one cell contain certain word, then total row will be hide and protect

    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hide Formulae in cell and to protect it with Password
    By jon112211 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-05-2015, 10:17 AM
  2. Sreelal How to lock or protect cell in shared work book without removing sharing?
    By ajeshvnair in forum Excel General
    Replies: 1
    Last Post: 12-08-2013, 06:30 PM
  3. how to work out rate based on total time and total amount
    By lisaathers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2013, 06:44 AM
  4. Password protect specific columns - Hide and protect ability to unhide.
    By ThomasCarter in forum Excel General
    Replies: 2
    Last Post: 01-17-2013, 08:39 AM
  5. Excel 2007 : How to hide formula in a cell and protect the cell as well?
    By mridulaparihar in forum Excel General
    Replies: 4
    Last Post: 04-11-2012, 09:59 AM
  6. how to hide and password protect comments in a cell
    By qmc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-25-2008, 12:07 PM
  7. Using a Cell to Hide/Unhide a Work Sheet
    By drgogo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2008, 02:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1