Macros Availability in Excel Workbooks

Where are macros available as long as a workbook is open?

a. the current worksheet
b. the current workbook
c. any open workbook
d. any saved workbook

Answer:

Macros in a workbook are available in any saved workbook.

The correct answer is d. any saved workbook.

When a workbook containing macros is saved, those macros can be accessed and executed from any open or saved workbook. Macros are stored within the workbook file, so as long as the workbook is saved, the macros will be available.

← Data analysis in customer relationship management Zooming a worksheet in microsoft excel →