Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

To enter VBA code, press Alt + F11 to open the Visual Basic Editor. In the Project Explorer to the left, choose ThisWorkbook and enter the code.

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code.

To enter the procedure, press Alt + F11 to open the Visual Basic Editor (VBE). In the Project Explorer to the left, select ThisWorkbook so you can run the procedure in any sheet.