VBA & Macro Problems

Fix Personal Macros Not Appearing in Generated Excel Workbooks

Adam DavisAdam Davis Nov 13, 2026 868 views

Question details

Find out why a macro in the Personal Macro Workbook is not available when working with files generated by another application.

Fix Personal Macros Not Appearing in Generated Excel Workbooks
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the macro list

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.

2
Check that PERSONAL.XLSB is open

Select View > Unhide and look for PERSONAL.XLSB in the list. The Personal Macro Workbook is normally hidden, so cancel the dialog after checking.

3
Inspect the macro procedure

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.

4
Review file warnings

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.

Check Personal Macro Workbook availability and macro scope
The generated file may affect the macro: If the macro is listed but fails when run, its code may depend on workbook names, sheet names, or features that differ in the generated file. The file format or structure may also contribute, but the cause has not been confirmed.
Free Microsoft Office alternative

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.

Open and edit common Excel formats, including XLSX and XLSReview generated spreadsheet data in WPS SpreadsheetsUse a familiar interface for a smoother move from Microsoft OfficeWork with a free, lightweight office suite
QA img-9

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.