Adding "Save" Button in Excel If you want to add a VBA save as button in Excel, you can do so using the "Developer" tab in the ribbon menu.

Open your worksheet in Excel. ALT-F11 (opens the VBA coding window) Copy/Paste the above code into the editor ALT-F11 (switches back to Excel) Save-As a Macro-Enabled Workbook ...

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...