Click the cell where you want to create a macro button for exporting your chart to a new PowerPoint presentation. After you click the selected cell, the Assign Macro window appears on the screen.

Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data. Open the form in ...

Create a hyperlinked text box button. Anywhere in the workbook, insert a Text Box (from the Insert tab’s Shapes menu), label it Return to the Table of Contents, and format the button to your desire.

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...