Many times, such codes may not work correctly until or unless you turn on the Trust access to Visual Basic Project setting. Note: In every instance, we have used Microsoft Excel for demonstrations.

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.

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.