Results 1 to 6 of 6

Disable Closing Of Workbook Until Cells Receive Data

Threaded View

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

    Question Disable Closing Of Workbook Until Cells Receive Data

    Okay, I don't know what our options are here, but I have a possibly odd question:

    I'm looking for a code that, upon the closing of the workbook, checks to see whether all the cells in Batch 1 contain data. If they all don't, then the workbook can be closed without further ado, but if they all do, then it should check to see if all the cells in Batch 2 contain data. If they all do, then the workbook can be closed, but if any of them don't, a message should pop up saying 'Hold it, you ain't goin' nowhere until you put some data in all those cells over there first.'

    This is Batch 1:
    Cells C2-C6
    Cells C8-C13
    Cells F6-F14

    This is Batch 2:
    A18-A22

    Any thoughts?
    Last edited by swordswinger710; 06-08-2012 at 01:06 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.

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