+ 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 Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    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,643

    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 Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    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)

Similar Threads

  1. Exit sub if even row selected in specific column
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2014, 02:09 PM
  2. Replies: 8
    Last Post: 10-30-2010, 08:07 PM
  3. Writing a macro that will exit a spreadsheet
    By Dave Doc in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-26-2006, 09:45 AM
  4. [SOLVED] Run a dos batch file as soon as I exit/save the spreadsheet
    By Lynda in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-05-2005, 03:05 AM
  5. Move to a specific cell on exit of current
    By jafo1 in forum Excel General
    Replies: 3
    Last Post: 06-24-2005, 04:29 PM

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