Results 1 to 7 of 7

Prevent user from closing worksheet if cell is blank

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Fairbury NE
    MS-Off Ver
    Excel 2007
    Posts
    70

    Prevent user from closing worksheet if cell is blank

    I'm not sure how to do this and hoping someone can help. I have a worksheet that is used by multiple users. For example, in Row 2, User 1 needs to enter data into the first five columns (A-E) and User 2 needs to enter data into the next five columns (F-J). I've protected each of the areas so that each User can only access their respective area.

    What I would like to do is have User 1 complete all cells in their range (A-E) for a specific line (i.e., when something is typed into a row, that row needs to be completely filled out (A-E). Rows below the entry line (blank) do not apply. If they try to save and exit the file without doing so, I need a message prompt to state they need to complete their fields.

    My second issue is that this is a worksheet that has been used for many years and there are several cells in the rows that may be blank. Since we cannot backfill this data, the cells need to remain blank. So, the range this code would be applicable to would be the columns (A-E) and the rows from current going forward (i.e., beginning at line 1000).

    I'm a beginner in writing vba code and everything I've attempted has failed.
    Last edited by maryren; 11-15-2013 at 12:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Prevent the users from closing the worksheet
    By jy7788 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2013, 05:44 AM
  2. Prevent user from typing on worksheet?
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2009, 04:09 PM
  3. Prevent a user from closing a userform
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2007, 03:03 PM
  4. [SOLVED] prevent blank cell in excel worksheet
    By jatman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2006, 10:08 AM
  5. [SOLVED] prevent a user leaving a blank cell in excel2003
    By Ian Varty in forum Excel General
    Replies: 1
    Last Post: 04-15-2005, 09: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