The location to store macros that can be use in any workbook is personal macro workbooks.
Macro is a feature in excel to set a action that can be executed as many times as user want. The macro can also be saved, recorded, or even named.
The main purpose of macro is to be use for repetitive tasks such as data manipulation or reporting data automatically. So, it will reduce time and effort for use from manually completed that tasks.
The macro that want to be saved can be stored on personal macro workbook after saved or stored the macro become available for any workbook to be used.
Learn more about macro here:
brainly.com/question/9101956
#SPJ4
