Thread: Command Button Prompt Save As?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rich
 
Posts: n/a
Default Command Button Prompt Save As?
Thank you! I'm extremely new.

How about a some sort of close after the save is made?

Private Sub CommandButton1_Click()
Application.Dialogs(xlDialogSaveAs).Show
Application.Close??
End Sub

Reply With QuoteReply With Quote