1. M

    VBA Disabling 'Saving As' Popup

    How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...
  2. M

    Application Quit closing down all instances of Excel

    I've been fighting with application.quit for a while now because it wouldn't close excel. I had this in the open even and first check to see if the user had read write privileges to a folder they will need for everything to work. I got that squared away by putting and Exit Sub after the...
  3. W

    Focus on current wb for quit

    I wrote this to force exit without saving anything. Works fine if it is in the active workbook but when I move it to my Personal.xls it does not work. On the intended workbook. Any ideas? Sub Quit() Application.DisplayAlerts = False ThisWorkbook.Saved = True Application.Quit End Sub
  4. L

    How can I add an output option to my macro?

    How can I add a message pop up when the user clicks on my quit macro to display are you sure you want to quit the spreadsheet? With two options saying 'yes' and 'cancel'? Sub CloseButton() Application.Quit End Sub Thank you!
  5. P

    Application.Quit doesn't work

    Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Dim sh As Worksheet Application.DisplayAlerts = False For Each sh In ThisWorkbook.Sheets Select Case sh.Name Case "Exhibit " & """I"" ", "page 2" Call...
  6. G

    Application.Quit doesnt terminate the Process

    Hello, i have following Problem: I wrote a Macro in Word, that opens an Excel file, changes stuff and saves ist again. When it runs a second time i get "method rows of object _global failed" as Error. (It works fine, if i close Word inbetween the runs). I suppose it's because the EXCEL:EXE *32...
  7. A

    Application.Quit Help

    Hi I’m writing an Outlook macro that looks in the incoming mails and, selects the specific mails, opens the attachments (only excel files), and copy the contents into another workbook, the process is really simple. Anyway after I close the workbooks, and the application, the Applications keeps...
  8. S

    workbook_open() not firing with application.quit

    I hope someone can help me with this one. Here goes. I am having a problem around the workbook_open event. First let me explain what I am trying to achieve. Basically, I want to start logging the execution of about 30 scheduled tasks which open various workbooks (which perform different...
  9. P

    Cannot quit Mircrosoft office Excel.

    Hi, This is my first post in Mr.Excel (Though i'm reading here from past a year). I've designed an excel application in which a userform will be active all the time showing on the desktop (somehow i managed to hide the excel application on the tastbar) Now when I try to Logoff / Shutdown...
  10. G

    Application.Quit does not work when ActiveWindow.Visible is False

    Here's a real head scratcher...Within the BeforeClose event, I call one of two procedures depending on whether the workbook is the only workbook in that particular instance of Excel. The first works fine. The second ends up working exactly like the first despite the use of Application.Quit...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...