These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

To reference them in VBA, use the name of the .NET class library as shown in the previous example. For instance, if you create a class library named SalesComputations, refer to that name in your ...

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

For example, you can use Visual Basic scripts, record and use macros, use Relative References, install add-ins, and more. However, this tab is not available by default due to security concerns.