Command Button Prompt Save As?
 

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

Command Button Prompt Save As?
 

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

"Rich" wrote:

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

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

Command Button Prompt Save As?
 

Found it!
Application.Quit