+ Reply to Thread
Results 1 to 1 of 1

Unlock a cell based on another cells value

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    8

    Unlock a cell based on another cells value

    Hello
    I have attached a sample of what I would like to create. I have colleagues who will populate the yellow shaded areas only if column 'A' has a loan number populated. All of the column 'A's will not always be completely full as in the example attached. So, I would like to only allow changes to the yellow shaded area assuming there is a loan number populated in column 'A'. Currently, I have the sheet protected so only the yellow areas can be changed, but I would like to see all of the yellow areas protected if there is nothing under column 'A'.

    Anyone have any ideas?

    There is no password to unprotect the sheet I have attached.

    Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. lock/unlock cell based on another cells input
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-21-2013, 03:17 PM
  2. Lock and unlock a cell or two cells based on a value of another cell
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2013, 07:34 PM
  3. How to lock and unlock a range of cells based on certain cell's value?
    By potato in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-25-2012, 04:34 AM
  4. unlock cell based on another cells input
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2009, 02:18 AM
  5. Unlock cell based on merged cells input
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2009, 06:04 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1