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.