using Office 365. I have a workbook the macro I wrote isn't showing up in the view macros box.

Question

using Office 365. I have a workbook the macro I wrote isn't showing up in the view macros box.

Abderrazaq Abbaouy 20

Office 365. In Excel workbook the macro I wrote isn't showing up in the view macros box. the file is saved as xlsm.

Accepted answer

1 additional answer

Your answer

Answer 1

triptotokyo-5840 36,616 Volunteer Moderator

I_have_a_workbook_the_macro_I_wrote_isnt_showing_up_in_the_view_macros_box - Is it a Private Sub - If YES then it won’t show up there.

Abderrazaq Abbaouy 20 Reputation points

2025-08-12T20:00:42.44+00:00

thanks

Answer 2

Are you looking at "all open workbooks" at the bottom of the Macros dialog?

Is your macro security blocking macros? Check in Excel's File > Options > Trust Center > Trust center settings.

Did you save the workbook after writing the macro? (I've done this more than once, usually after editing a macro.)

Is it an automatic macro? Macros with names in the form of "Sub Macroname(something as string)" won't show up in the macro list, you need to open the VBA Editor to see the macro or run it from another macro that you can see.

Share via

using Office 365. I have a workbook the macro I wrote isn't showing up in the view macros box.

1 additional answer

Your answer