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