Excel crashing after running workbook save, close vba code

[dss28]

While executing the following code I always get a message that

"MS OFFICE EXCEL HAS STOPPED WORKING... ...... CHECK ONLINE FOR A SOLUTION...... CLOSE THE PROGRAM TO RESTART ......."

Request to guide

Private Sub cmdLogout_Click()
    
    ActiveWorkbook.Save
    ActiveWorkbook.Close
    Application.Quit

End Sub

 

[dss28]

Is there any quick way to review / see which form may have been active behind.
or is there any command that will close all the open userforms at once while closing the workbook
this will be a great help to me...

 

[dss28]

to add further .... for all the userforms, I am using following code

for example

frmXXXX.Show to show the userform and

frmXXXX.Hide to close the userform

 

[RoryA]

Hide does not unload a form - it literally hides it. You need Unload frmXXXX to actually unload it from memory.