Why are my Excel macros not working?

Why are my Excel macros not working?

Macros may have been disabled in Excel When you first open a macro-enabled workbook that you didn’t create, Excel usually disables macros and asks you to confirm whether they should be enabled. You should never enable macros if a macro-enabled workbook comes from a source that you don’t trust.

How do you fix macros not working?

Change macro settings in the Trust Center

1. Click the File tab.
2. Click Options.
3. Click Trust Center, and then click Trust Center Settings.
4. In the Trust Center, click Macro Settings.
5. Make the selections that you want, then click OK.

Why do macros disappear Excel?

You must make sure you’re in protected mode so no macros/libraries are activated. Go to Developer, Visual Basic, then click on “Debug” and click on “Compile VBA Project”.

How do I enable macros in Excel 2016?

How To Enable Macros In Excel 2013-2016

1. Click the File Tab (top-left most tab in the window)
2. Click the Excel Options butto.
3. Click Trust Center in the menu on the left.
4. Click Trust Center Settings in the window on the right.
5. In the new window that opens click Macro Settings in the menu on the left.
6. Select Enable all macros.

Why are my macros missing?

Why is my Excel VBA script no longer working?

After a recent windows update, a previous Excel vba script that was working, no longer functions correctly. The macro operation, when working, opens a csv file that is defined in the active workbook as String aString. The csv file contains a list of variables and corresponding values for those variables.

What ended up fixing macros settings and VBA?

What ended up fixing the macros settings and VBA was doing an online repair install of the Office 2016 suite. I lost all the recent file history but it did fix the issue I was having. I just wish Microsoft would not put out an windows update that would break it’s own apps.

Does it matter if macro is enabled or not?

If it really does not matter if macro enabled then I leave it as macro enabled. Next. With all projects that take a lot of time you should save versions of the workbook so you can go back if you have a problem. It is not unusual to lose a workbook by corruption simply because the developer has done something wrong in the VBA code.

What version of Excel does the activeworkbook macro work?

The macro works perfectly in Excel build Version 1902 (Build 11328.20318) but does not work in Version 2002 (Build 12527.21416). The original code was originally written in Excel 2016 and has been functioning perfectly up until the latest company approved version of window 10 was updated. strWorkBook = ActiveWorkbook.Name