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 ...

Such buttons often run macros that you write using Visual Basic. When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window.