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 ...

Click the new command button. Excel prints the active spreadsheet on the default Windows printer without displaying the normal "Print" dialogue box.