Visual Basic for Applications can make helpful items such as links appear on screen. You can open an external spreadsheet by clicking a link in an Excel spreadsheet. For instance, you might add an ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...