Public Sub UnloadAllForms() Dim objForm As Form ' Loop through all the forms and unload each For Each objForm In Forms Unload objForm Next Set objForm = Nothing End Sub