Forum Discussion
samsamsamsam
Jan 04, 2024Copper Contributor
macro problem in excel
Hello, I made a bunch of macro for a project. The problem is that idk how but now when I'm looking for them in the list there is nothing. I can see them on visual Basic but i can't on the "macro list...
kimjl
Jan 04, 2024Copper Contributor
If your macros are not appearing in the macro list but are visible in Visual Basic, it might be due to issues with the macro-enabled workbook. Ensure the macros are saved in the workbook and try reopening it. Check for any filtering or sorting in the macro list, and if the problem persists, consider exporting the macros, creating a new workbook, and importing them back in. Additionally, verify that the macros are not disabled by any security settings in Excel, and if needed, adjust your trust center settings for macro visibility.
Take a look at: https://techcommunity.microsoft.com/t5/excel/macro-to-sort-excel-sheets-by-name-according-to-a-custom-order/m-p/3858134#M196258
Also visit: https://fashionluva.com/