So, individuals can create a link from the command button to a worksheet in your workbook. In this tutorial, we will explain how to use the Command button to navigate between worksheets in Excel.

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

Click the command button you created on the form. VB6 sends the data from the form to a new Excel spreadsheet using the file name you entered in the code.