Answer :
To have your macros available when creating additional workbooks, you should consider the option a. creating a macros workbook.
A macros workbook, also known as a Personal Macro Workbook (PMW), is a central repository for storing your commonly used macros. By storing macros in the PMW, you ensure that they are accessible whenever you create or open other workbooks in Excel. Writing your macros directly in VBA (Visual Basic for Applications) is a powerful method, but it does not guarantee their availability across all workbooks. Storing workbooks on a shared network drive only affects their location and accessibility for multiple users but doesn't affect macros availability.
Leaving open all workbooks containing macros is not practical, as it can clutter your workspace and cause performance issues. Creating a macros workbook simplifies your workflow and provides a seamless experience. When you store your macros in the PMW, they become available in the background every time you open Excel. This allows you to execute your macros quickly and efficiently, regardless of the workbook you are working on.
In summary, to ensure that your macros are available when creating additional workbooks, create a Personal Macro Workbook to store them. This method offers a convenient, efficient, and organized way to manage and access your macros across different workbooks in Excel. Therefore, the correct answer is option a.
know more about macros workbook here:
https://brainly.com/question/31689399
#SPJ11
