a macro ?
a macro ?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: a macro ?

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I created a workbook for a class project. I have navigation buttons that move me thru it forward and backward. What I would like to do is create a macro for a button that closes excel and doesnt ask for the save prompt.

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try:

    Code:
    sub clsIt()
    Dim myAp As Excel.Application
    thisworkbook.close false
    myAp.quit
    end sub
    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-04-04 17:01 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the help. However it doesnt close Excel. It closes the Workbook just fine but not the program. Any suggestions about that ?

  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try the following:

    With Application
    .DisplayAlerts = False
    .Quit
    End With
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank You that work super
    Much appreciated.
    I gave this site to my teach.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    357
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    357
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    eddieque,

    What do you mean you have a macro that move you forward and backward through your workbook? You mean go from one worksheet to the next and back?

    Care to share the code for that?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com