+ Reply to Thread
Results 1 to 5 of 5

Workbook closing but worksheet staying active??

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2002
    Posts
    9

    Workbook closing but worksheet staying active??

    So, I have this script that I had running, but modified to sort data into different sheets based on an input box. It works, and does everything I want it to, but now, every time I run it, a new instance of Excel runs in the background. As far as I can tell(and I don't really know much about this sort of thing), is that somehow the workbook is closing, but the worksheet is staying active. I've been looking up stuff and reading for hours trying to figure this out, am I at least heading in the right direction?? This is a basic script inserted into a PC DMIS program(outside of Excel). I have the changes I made to achieve the sorting process(2 paragraphs) marked with "worksheet input:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Workbook closing but worksheet staying active??

    you have 2 lines of
    Please Login or Register  to view this content.
    so the first one gets lost in the sea when the second line comes

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2002
    Posts
    9

    Re: Workbook closing but worksheet staying active??

    Oops, that must be left over from some failed attempt at something that I missed when deleting

  4. #4
    Registered User
    Join Date
    10-04-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2002
    Posts
    9

    Re: Workbook closing but worksheet staying active??

    Tried removing that line, but am still having trouble, uggggh

  5. #5
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Workbook closing but worksheet staying active??

    add a
    Please Login or Register  to view this content.
    after
    Please Login or Register  to view this content.
    see if it helps?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Closing non-active workbook
    By patelh9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2010, 12:09 AM
  2. Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Active W
    By John Vieren in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2009, 09:22 AM
  3. closing the active workbook
    By jmoffat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-03-2006, 08:21 AM
  4. [SOLVED] Closing Hidden Workbook when Active Workbook is Closed
    By SusanK521 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-23-2005, 08:05 PM
  5. [SOLVED] Closing a workbook and printing a non-active page
    By Sleeping Bear in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2005, 09:05 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