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.

How to Make a Button in VBScript Using Excel. Microsoft Excel's form controls let you add buttons to your spreadsheet to perform functions. For example, if a spreadsheet invites coworkers to enter ...