+ Reply to Thread
Results 1 to 2 of 2

On Exit commands?

  1. #1
    Registered User
    Join Date
    02-10-2005
    Posts
    10

    On Exit commands?

    Hello again folks,

    Here is the breakdown of what I would like to do...

    I have a workbook (main.xls) that opens 3 other workbooks (ken.xls, mike.xls, other.xls) and hides them upon launch of the main.xls workbook.

    What I would like to do is when I click the X in the top right corner of the main.xls (to close the workbook), the remaining 3 workbooks (ken.xls, mike.xls, and other.xls) close without prompting to save them.

    Is there a way to do this, and could you all guide me in the right direction to do this.

    Thanks and I lookforward to your responses and I will be quick with counter responses as well.
    Nick
    U of Toledo
    Marketing and E-Commerce

  2. #2
    Registered User
    Join Date
    02-10-2005
    Posts
    10
    Welp figured it out all by my lonesome =)

    But Incase anyone else had this issue I'll post the fix:

    Sub Auto_Close()

    Windows("KenContacts.xls").Activate
    ActiveWorkbook.Close SaveChanges:=False

    Windows("OtherContacts.xls").Activate
    ActiveWorkbook.Close SaveChanges:=False

    Windows("MikeContacts.xls").Activate
    ActiveWorkbook.Close SaveChanges:=False

    End Sub

+ 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