+ Reply to Thread
Results 1 to 7 of 7

Lock whole row

Hybrid View

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    96

    Lock whole row

    I need vba code in the sheet.if a cell contains value "Abid" then the whole row will be locked and become non editable till we change the cell value.
    Thanks for urgent reply

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Lock whole row

    Hello mubashar,

    ...and become non editable till we change the cell value.
    If the whole row is locked and non editable, how do you plan to change the Cell value?

    Regards.
    Last edited by Winon; 06-29-2016 at 04:42 AM. Reason: text
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Lock whole row

    Maybe try Data Validation?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Lock whole row

    @FDibbins,

    Exactly what I thought as well, but since the OP wanted VBA, I could not resist posing my question.

    Groete my vriend!

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Lock whole row

    Hey boetman, will be in your neck of the woods again soon - visiting son in CT and sis in Durbs

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Lock whole row

    Hey old man, any chance with a stop-over in Jhb? If not, I don't think I will ever use your travel agent. LOL

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Lock whole row

    Not sure what the travel plans are but I think we stop in JHB, will get you the details

+ 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. [SOLVED] How to Lock a Row
    By Shytott in forum Excel General
    Replies: 7
    Last Post: 11-15-2012, 10:56 AM
  2. Lock VBE or Lock Macro
    By srinivassurapareddi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 03:08 PM
  3. Replies: 2
    Last Post: 02-22-2012, 10:10 AM
  4. Lock a Row and everything below it
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-30-2011, 07:25 PM
  5. Can I lock cells or do I have to lock the worksheet?
    By jmbtexas in forum Excel General
    Replies: 4
    Last Post: 11-11-2008, 02:26 PM
  6. [SOLVED] How can Excel vba detect if Caps Lock or Num Lock is on?
    By abc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2005, 02:20 AM
  7. [SOLVED] lock out
    By chaimyes in forum Excel General
    Replies: 0
    Last Post: 05-19-2005, 04:06 PM
  8. Lock it in....
    By JP in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-05-2005, 07:06 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