Fix Personal Macros Not Appearing in Generated Excel Workbooks
Question details
Find out why a macro in the Personal Macro Workbook is not available when working with files generated by another application.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user runs a personal macro on manually created workbooks and wants to use it with workbooks generated by a laboratory management system.
- Observed behavior
- The macro works with manually created files but does not appear for generated workbooks. Copying the data to another sheet allows the macro to run, but the generated workbook is complicated to copy.
Open both a generated workbook and a manually created workbook in Excel, and confirm that the macro is stored in PERSONAL.XLSB rather than in either file. Check whether the generated file opens in Protected View or displays a security warning.
Check Personal Macro Workbook availability and macro scope
Use Excel's macro list and Visual Basic Editor to check whether the personal macro is loaded and available for the generated workbook.
A macro stored in PERSONAL.XLSB does not need to appear inside each generated workbook. It should be available from the Personal Macro Workbook while that workbook is open.
Open the generated file and select View > Macros > View Macros. In the Macros in list, select All Open Workbooks or PERSONAL.XLSB and look for the macro.
Select View > Unhide and look for PERSONAL.XLSB in the list. The Personal Macro Workbook is normally hidden, so cancel the dialog after checking.
Open Developer > Visual Basic and find the procedure under PERSONAL.XLSB. A public Sub without arguments in a standard module can appear in the Macros dialog; private procedures and procedures requiring arguments do not normally appear there.
If the generated file opens in Protected View, review its source and select Enable Editing only if you trust it. Check any macro security warning before enabling content.

Copy the required data into a standard Excel workbook
Use a standard workbook as a workaround when the personal macro works there but not with the generated file.
Work with Excel-Compatible Spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing common Excel formats. It can help you move spreadsheet work between applications, but it does not fix Excel's Personal Macro Workbook behavior.

Frequently Asked Questions
Why isn't my personal macro stored in the generated workbook?
A personal macro is stored in PERSONAL.XLSB, not automatically copied into each workbook. In Excel, open View > Macros > View Macros and check All Open Workbooks or PERSONAL.XLSB.
Why can I see the macro in one workbook but not another?
Check the Macros in selection in View > Macros > View Macros. If the generated file is in Protected View or has an unusual structure, those conditions may also affect how you use the macro.
Why doesn't a VBA procedure appear in the Macros dialog?
In Developer > Visual Basic, check whether the procedure is a public Sub without arguments in a standard module. Private procedures and procedures that require arguments do not normally appear in the dialog.
What can I do if copying the generated workbook takes too long?
Contact the laboratory management system vendor and describe which generated files are affected and which macro works in a standard workbook. Ask for help with the generated file's Excel format or structure.




