I have a user form that pops up to ask the user if they want to back u
their file after seven days. Everything works great except the for
pops up twice no matter if they chose yes, no, or cancel.
here is the "yes" code.

Private Sub CommandButton1_Click()
Unload Me
Application.DisplayAlerts = False

ActiveWorkbook.Save
ActiveWorkbook.SaveAs ("s:\shared machining\backup\S-Bay Finis
Paint.xls")
Application.DisplayAlerts = True

ActiveWorkbook.Close
End Sub

thanks for the help
--Jeffer

--
Message posted from http://www.ExcelForum.com