How to Program a "Save As" Button in Excel VBA. Offices and small businesses all over the world create countless numbers of Excel spreadsheets every day.

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

Press "Alt-F11" to launch Excel's Visual Basic editor. Double-click "VBAProject" in the Project window, and then double-click "Microsoft Excel Objects" to open a list of sheets in your workbook.