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.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Open Microsoft Excel, click the "File" tab, and then choose the "New" link. When the Available Templates window appears, type "ledger" into the search box, and then click the arrow button.

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.