Command Button Prompt Save As?

[Rich]

Is it possible to have a command button or Macro that can prompt the
user the Save As Dialog ?

 

[Bob Umlas, Excel MVP]

Sure -
Sub MySave()
Application.Dialogs(xlDialogSaveAs).Show
End Sub

 

[Rich]

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

 

[Rich]

Found it!
Application.Quit