Click the button in the spreadsheet to run the command. READ: Change Cell Background Color in Excel with VBA Editor What is the difference between VBA and script in Excel?

You can automate specific tasks by repurposing Word's built-in commands. It requires a bit of VBA, but it's super easy. Here's how.

You can use the same method to create many print functions in Excel using VBA. Steps for creating the print function button are the same; just the command syntax differs.

Click the "Command Button" in the Excel spreadsheet. Microsoft Word opens automatically and displays the file from the path you entered in the Visual Basic editor code window.