Forum Discussion
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".
3 Replies
Hi, you could check they're not set as Private in the Sub statement...or try setting them as Public
https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/sub-statementHave you by any chance added "Option Private Module" at the top of the module(s)? That hides those macros from the list. Can you type a name of a macro in the name box (even though you don't see it on the list) and run it?
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#M196258Also visit: https://fashionluva.com/
