Results 1 to 10 of 23

Thread: VBA Stop Workbook From Closing Unless Data Is Filled Complete

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    13
    Rep Power
    0
    NO good rick can I send you the actual file and you can look at it?

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by MATRIXOFFICE View Post
    NO good rick can I send you the actual file and you can look at it?
    Before you do that, describe "no good" for me so I have an idea what the code does or does not do correctly.

    Note: I'll be going to sleep soon, so if you respond and do not hear right back from me, you will know why.

  3. #3
    Junior Member
    Join Date
    Jan 2013
    Posts
    13
    Rep Power
    0
    thanks RIck - code is installed in this workbook but does not work at all - data in incident cell with no data in M N and O cells does not trigger
    the code at all

  4. #4
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Okay, I'll look at your workbook. You should be able to attach your workbook to your reply (a direct reply, not a quick reply) so anyone here can see it. If you have trouble doing that, you can send it directly to me at rickDOTnewsATverizonDOTnet (replace the upper case letters with the symbols they spell out).

    Edit note before going to sleep: I just want to make sure you realize the code I posted only executes when the workbook is closed (the wording in your last message made me wonder on that).
    Last edited by Rick Rothstein; 03-18-2013 at 02:31 PM.

  5. #5
    Junior Member
    Join Date
    Jan 2013
    Posts
    13
    Rep Power
    0
    file size exceed forum limit so I will email thanks Rick

Similar Threads

  1. Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  2. Auto Complete for Data Validation
    By IJC in forum Excel Help
    Replies: 1
    Last Post: 05-15-2013, 09:30 AM
  3. Replies: 2
    Last Post: 12-04-2012, 02:05 PM
  4. VBA Code to Open Workbook and copy data
    By Howardc in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 06:58 PM
  5. VBA code to copy data from source workbook
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 07-30-2012, 09:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •