where is this macro stored? this workbook personal macro workbook new workbook
where is this macro stored? this workbook personal macro workbook new workbook
Answer
Brief Explanations:
In Excel, when you record a macro and choose "This Workbook" in the "Store macro in" option, the macro is stored only in the current workbook. The Personal Macro Workbook stores macros that are available across all workbooks. A New Workbook would create a new workbook and store the macro there. Based on the image showing "This Workbook" selected for storing the macro, it will be stored in the current workbook.
Answer:
This Workbook