Thread: Macro to Close and save all changes
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charles Charles is offline
external usenet poster
  
Posts: 1
Default Macro to Close and save all changes
Greg,

Try

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
MsgBox "Be Sure You Save Before you close this Program"
ActiveWorkbook.Save
End Sub


Your Friend Charles

Ps it on your copy I sent you

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

Reply With QuoteReply With Quote