Excel 2021 cannot see loaded macros in the 'Macros' section of the development toolbar

琪 夏 20 Reputation points
2023-04-06T01:53:48.7766667+00:00

Excel 2021 cannot see loaded macros in the 'Macros' section of the development toolbar, clicking on the program in the VB will forcibly close the excel, but this situation only occasionally occurs in one table at the same time, not all tables.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,524 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,546 Reputation points
    2023-04-06T08:11:33.0066667+00:00

    Hi @琪 夏

    Could you please share us more details of your issue.

    Do you mean that clicking 'Macros' button, the macro name won't show up in the list, like the second image?

    Capture94

    User's image

    What version of Excel was this macro file created from, or did this macro created by one add-in?

    It's recommended to check whether this issue also occur with other verions of Excel.

    Besides, as the Excel auto-quit issue occurs only for a specific workbook, I suggest you right click one worksheet tab of the workbook > Move or Copy > Create a copy to have a check.

    You may also go to Windows Event Viewer > Windows logs > Applications > check whether there is any related error record. If so, please check its error module.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful