2] Navigate to worksheet using Command button Because the Design Mode is turned on, you can double-click on the command button to open the VBA Editor. In the VBA Editor window, type the following ...

You can set the print area of an Excel spreadsheet using the Print Area button to print only a selected area of a spreadsheet.