+ Reply to Thread
Results 1 to 3 of 3

Require Data To Be Entered In Cell Unless Selecting Specific Cells

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Require Data To Be Entered In Cell Unless Selecting Specific Cells

    I came across a problem with my workbook where the best solution I can think of would be this:

    I need to prevent data from being entered anywhere else on a worksheet unless Cell X1 receives data first - anywhere else, that is, except for Cells U6, O79, U86, O159, U166, and O239.

    How do I edit my existing code to do this?

    Please Login or Register  to view this content.
    Last edited by swordswinger710; 06-08-2012 at 06:19 PM.
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Require Data To Be Entered In Cell Unless Selecting Specific Cells

    Try changing the 4th line to

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Require Data To Be Entered In Cell Unless Selecting Specific Cells

    Thank you so much! That did the trick!

+ 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