The Visual Basic "Button" class lets you create a control on your VB projects that perform an action such as auto-save. VB also includes file classes that help you create functions to save files.

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.

These step-by-step instructions show you how to add the Developer tab to the Ribbon in Word and Excel 2016 and Office 365, and to use it to launch the Visual Basic Editor and access Visual Basic ...

Visual Basic for Applications (VBA) is a programming language embedded in Microsoft Office that can be used to automate processes and build functions.