Use Application.quit after close

Is there a way to use application quit for just "thisworkbook"

I mean:

I have several workbook's open, although if i close 1 and use application.quit (i need to use this code btw), it quits all workbooks.

Is there a way to close the application but just for this workbook? so i can keep the other workbook's safe?

No Application.Quit closes Excel. You would need to use Workbook("Name").Close or Activeworkbook.close or Thisworkbook.close.

Originally Posted by JOHN H. DAVIS

No Application.Quit closes Excel. You would need to use Workbook("Name").Close or Activeworkbook.close or Thisworkbook.close.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Call ResetAndStopClock

Select Case Workbooks.Count
    Case Is <= 1
        If ThisWorkbook.ReadOnly = True Then
            'FECHA O DOCUMENTO SEM GUARDAR
            'EM MODO LEITURA
            Application.DisplayAlerts = False
            ThisWorkbook.Saved = True 'apenas finge, não guarda
            ThisWorkbook.Save
            Application.Quit
        Else
            'EM MODO ESCRITA
            Call UnDoALL
            Call VisibleFalse
            ThisWorkbook.Save
            Application.Quit
        End If
        
    Case Is > 1
        If ThisWorkbook.ReadOnly = True Then
            'FECHA O DOCUMENTO SEM GUARDAR
            'EM MODO LEITURA
            Application.DisplayAlerts = False
            ThisWorkbook.Saved = True 'apenas finge, não guarda
            ThisWorkbook.Save
            'Application.Quit
        Else
            'EM MODO ESCRITA
            Call UnDoALL
            Call VisibleFalse
            ThisWorkbook.Save
            'Application.Quit
        End If
End Select
    
End Sub

tHIS IS what i have at moment, although have 1 problem:
Where line is bold, the file reopens after i close it, it saves perfectly, although it reopens if i have another file open

i already tested that solution, doesn't work cuz the application stills open

Originally Posted by MarvinP

So, you want some of the workbooks to stay open in Excel after you close Excel. I think this is impossible as closing Excel will also close all the workbooks too.

That is why I suggested only closing the specific workbook and leaving Excel open so the others were still in computer memory and working.

The bottom line is: If you close the application, all programs/files that are using that application will also close.

I know that, thats why the line is commented out. My problem is that in that line the excel reopens after i closed it. (ontime is turned off by macro 'resetandstopclock)

Please let me know what can i do

Yes as told before, i have ontime event although i stop it on before close event with macro "resetandstopclock" it works perfectly if thisworkbook is the only one open. If there is another excel ope, thisworkbook reopens after close

About buttons and shapes there are no links between workbooks, each one has its own