Closed Thread
Results 1 to 2 of 2

lock Excel cell after value is entered!!

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    39

    lock Excel cell after value is entered!!

    I have two worksheets. on sheet1 i have data which is.

    ID Name Last Due Mthy Rent Total Paid
    101 Sophia 0 300 300
    102 Liam -50 250 200
    103 Jacob 0 300 300
    On sheet2 i have made search box using Index feature which is like

    ID
    Last Bal
    Monthly
    Total
    Paid
    I have managed to get the data when i entered ID in Cell B2 and when i am entering data in B5. it should automatically enter into sheet1 paid column respective to their ID. after that it should be copy and paste special as value and locked that cell. so that i cant enter any value in it.
    for reference i am uploading excel file here.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: lock Excel cell after value is entered!!

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Needing to lock cell if value (x) is entered
    By RobertJr in forum Excel General
    Replies: 2
    Last Post: 06-20-2014, 03:11 PM
  2. Replies: 2
    Last Post: 08-30-2012, 06:08 AM
  3. Lock Data in Cell after entered
    By CrimsonPlague29 in forum Excel General
    Replies: 0
    Last Post: 05-09-2006, 06:55 AM
  4. [SOLVED] How do I lock a cell automatically after it has data entered.
    By Dandy in forum Excel General
    Replies: 0
    Last Post: 03-30-2006, 07:45 AM
  5. [SOLVED] how can i lock cell immediately if any value Entered?
    By Sureshsmartdc in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-20-2005, 07:05 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