Excel macros disappeared

0 votes
My Excel file had a load of macros and now when I click Developer - Macros, they don't show up in the list, the list is empty. How do I fix?
Sep 25, 2022 in Others by Kithuzzz
• 38,020 points
16,677 views

1 answer to this question.

0 votes
Open the file in protected mode (usually I save it on the shared network so it prompts me to "Enable Content"). You must make sure you're in the protected mode so no macros/libraries are activated.

DON'T ENABLE CONTENT

Go to Developer, Visual Basic, then click on "Debug" and click on "Compile VBA Project".

Save the file  > Close  > Reopen.
answered Sep 26, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Way to run Excel macros from command line or batch file?

Solution Open the workbook and run the macro ...READ MORE

answered Nov 14, 2022 in Others by narikkadan
• 63,720 points
6,687 views
0 votes
1 answer

How should I show the Developer tab in Excel using Macros? (Excel VBA)

You can activate (mode=1) or deactivate (mode=0) ...READ MORE

answered Nov 15, 2022 in Others by narikkadan
• 63,720 points
593 views
0 votes
1 answer

How do ask ChatGPT with API from Excel macros (vba)?

A few things that will help. Don't ...READ MORE

answered Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
2,028 views
0 votes
0 answers

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

Jul 18, 2021 in Others by Sri
• 3,190 points
777 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,096 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
1,017 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
4,297 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,172 views
0 votes
1 answer

Trouble with excel macros (possibly encoding?)

To solve your issue: Replace your macro names ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,720 points
781 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP