+ Reply to Thread
Results 1 to 8 of 8

Desperate Help needed with Locking out a range of cells based on selection from 1 cell

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Desperate Help needed with Locking out a range of cells based on selection from 1 cell

    Apologies but I am self taught on Excel and have reached the limit of my abilities!! I have created a spreadsheet that has a range of cells with drop down lists. What I want to do is lock out a series of cells based on the choice made in one cell. I have looked at the threads on the site but have no knowledge what so ever of Visual Basic and therefore the coding means nothing to me. What I need help with is the following.

    Cell Y15 (Drop down list choices of Y or N). When N is chosen I want the adjacent cells of Z15 to AF 15 to lock so that nothing can be entered. These have drop down menus as well as they need to be completed if Y15 has Y chosen from the drop down list.

    I am using Excel 2010 and really need the 'idiots' guide to how to either create a formula or to do what is need to enable me to sort this out and then to be able to replicate it for other parts of the workbook.

    I am now at my wits end...so any help or advice would be really appreciated

  2. #2
    Registered User
    Join Date
    04-09-2012
    Location
    São Paulo, Brazil
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Vcummi,

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-31-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Hiya

    Not sure how to try it. Do I need to insert the code somewhere? Sorry it that's really basic but I am learning as I go!

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

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Enter this formula in your Data Validation for Z15, and adapt it for every adjacent Cell as far as you wish to go. No VBA Code needed here.

    Assuming V11=Y and V12=N

    Please Login or Register  to view this content.
    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] .

  5. #5
    Registered User
    Join Date
    05-31-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Sorry, again I am completely lost? In my column Y15 I have put in drop down box that contains Y or N. If a person chooses N here then I want the next columns (Z15 to AF15 to lock so that nothing can be filled in using the drop down boxes specific to those cells.

    I am therefore not sure what you mean by V11 and V12? And even more basic than that....how do U use data validation to enter that forumula.....what do I choose under settings on that tab?

    I really am sorry for this but I am struggling.

    Thanks for your help

    Val

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

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Check out the attached WorkBook.

    Hope that clear things up a little

    Please also see the Please Consider notes at the bottom of this Post
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-31-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Many thanks I will have a look and come back to you. I am not sure what you need me to do with regards to the last sentence? Sorry!

  8. #8
    Registered User
    Join Date
    05-31-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Desperate Help needed with Locking out a range of cells based on selection from 1 cel

    Thanks everyone I think have cracked it now....if it hasn't 'cracked' me!! No doubt I will be back again, but in the meantime all the help has been really appreciated.

    Val

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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