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.

When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window. Once you have made the button, you can then code the VBA event that you want it to run.