+ Reply to Thread
Results 1 to 2 of 2

Lock a cell based on a specific criteria

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Lock a cell based on a specific criteria

    At present (you may have seen some of my other posts) I'm creating a timesheet for use by external managers, this means I cannot use VBA as many are not able to use macros on their systems.

    As a result I'm trying to be able to lock down data entry on specific cells (on the Manager Entry tab) based on whether or not the person selected in cell B5 then has the allowed type of overtime on the Source tab.
    I've attached an example if it is of any use.
    Attached Files Attached Files
    Last edited by distortthecode; 04-29-2014 at 08:43 AM.

  2. #2
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Lock a cell based on a specific criteria

    I have marked this as solved as I have sacrificed one form of Data Validation for another and just pulled through from locked & hidden VLookups

+ 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 specific cells in a row based on another cell content of the same row
    By st_rod000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2014, 02:58 AM
  2. [SOLVED] Add numbers based on criteria from specific cell on same row
    By nitreb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2013, 05:13 PM
  3. [SOLVED] Search for a specific cell based on two criteria
    By RoVo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2006, 01:10 PM
  4. [SOLVED] Transfer single cell information to specific cell based on user criteria
    By RoVo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2006, 11:30 AM
  5. [SOLVED] Lock data in a cell a specific cell based on selection on other ce
    By CrimsonPlague29 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-10-2006, 06:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1