+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : blocking access to certain cells based on previous cells

  1. #1
    Registered User
    Join Date
    01-16-2007
    Posts
    94

    blocking access to certain cells based on previous cells

    I am trying to build a form in excel 2007 and make it so that you can only fill in certain cells based on answers previously entered.


    Basically I want a given cell to be protected or unprotected based on wether or not another cell has been used.

    I assume this would be done using if statments but Im not sure.

    any ideas?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,498

    Re: blocking access to certain cells based on previous cells

    In the absence of any other replies as yet ... it's not something I've come across.

    You could probably do this fairly easily in VBA but (AFAIK) it would need a Worksheet event to monitor the contents of the "control" cell. The worksheet would have to be protected for the locked status of the cell to have any effect.

    Regards

  3. #3
    Registered User
    Join Date
    01-16-2007
    Posts
    94

    Re: blocking access to certain cells based on previous cells

    Hmm maybe I will just start by having the cells change colour when appropriate and see if that works or if I need to go further.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,498

    Re: blocking access to certain cells based on previous cells

    It all depends on what you are trying to do.

    If you want to limit what is selected, you might be able to make use of dependent lists in Data Validation.

    In this, you select entries from one list; each entry in that list has another list associated with it. In another cell you would have a selection which would be related to the option/list selected in the first cell.

    See Debra Dalgleish's Contextures web site:

    http://www.contextures.com/xlDataVal02.html

    Regards

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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