+ Reply to Thread
Results 1 to 5 of 5

Exit specific spreadsheet

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Exit specific spreadsheet

    I have the code below, to exit a spreadsheet. If there are other spreadsheets open, it asks if they are to be closed as well, and is then meant to either close all the spreadsheets, or just the active sheet. The cancel leaves all the spreadsheets open. Cancel works, but the other 2 choices do nothing. I am not a great coder, but can some-one tell me what I'm missing here?

    Please Login or Register  to view this content.
    Thanks - OM1950

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Exit specific spreadsheet

    The OutPut case can only return 6 or 7
    Last edited by AB33; 02-05-2015 at 08:21 AM.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,032

    Re: Exit specific spreadsheet

    Change this,
    Please Login or Register  to view this content.
    to this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Exit specific spreadsheet

    Should be

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-29-2013
    Location
    Townsville, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Exit specific spreadsheet

    Thanks very much Norie. I can see I'm going to have to do more reading on the use of Case! Worked excellently

    Thanks again,
    OM1950

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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