If you close or cancel out of the dialog box, it will return "False." Logically, you'll likely want your Excel VBA SaveAs button to actually save the file using the file path that the user ...

Click Options on the Backstage View. An Excel Options dialog box will open. Click Advanced on the left pane. In the Display section, uncheck the checkbox for the Show formula bar option.