Curt,

You need to show the form as non-modal.. Give this a try:


Private Sub Workbook_BeforeClose(Cancel As Boolean)

UserForm7.Show False
DoEvents
ThisWorkbook.Save

End Sub


--
Hope that helps.

Vergel Adriano


"Curt" wrote:

Have a befor close save event works fine want to if possible have a userform
show while save is going on then close workbook ie excel Tried this no go
also tried an option button on userform no go.
Would like userform7 to show while save is goung on them shut down. Hope I
made this understandable.
Thanks to all

Private Sub Workbook_BeforeClose(cancel As Boolean)
UserForm7.Show
' ThisWorkbook.Save
'UserForm7.Show
End Sub