Why won't Excel let me run a macro?

Does Excel macro work on Mac?

So this week is our week for testing a bunch of Excel macros.

They have to be tested, not just run by themselves as an end user, but they also have to be tested in the context of a macro. For example, we are going to have users who are supposed to run a macro which will do something. What they want to be able to do is enter a few parameters and it will make those calculations so they can be confident that when they run the macro the end result will be the same regardless of the data they have entered.

For these types of macros, what you are going to see is that there is actually an option for you to save the macro. The SaveAs feature on Mac is not a lot better than that on Windows. So I recommend that you run a macro before you do anything on your Mac with an Excel file. Then make sure you save the file, so you can test and use it later.

I think you are probably better off on the Mac doing a macro using Excel on the Mac because there is a lot of functionality within Excel that is still not available on Mac. Like the fact that you can't change the column and row numbers when you paste. There is a good reason for that - because, from a security standpoint, Microsoft hasn't yet figured out how to allow you to change those fields. In the Excel file on the Mac, however, you can change those fields.

So I would strongly recommend running your Excel macro through the Mac version. And then save the file for future use. Now that you know how to save macros, let's get to the testing part.

Macro for a Calculator. You are going to start with one that is relatively simple, but that would be useful for someone who has to work with their data in some way. So you have a table of numbers. You want to know if there is any way to make them all multiples of 25. For this one, you are going to go to the Home tab and you are going to choose Insert > Module. This will bring you to the Insert Ribbon and then it has the Macros button down here on the right side.

Macro for Summation/Subtraction. Let's start with this one. When you press Enter you will see the code window open up, and it looks like this.

Why are my macros suddenly not working in Excel?

So, for some reason macros no longer work after I upgraded to the October 2026 release of Excel.

I am a big advocate of using macros to automate processes, however they simply will not execute in the way they used to. When I launch Excel, it opens without a "New" or "Workbook" tab. All of my buttons such as 'New' and 'Workbook' are gone! Clicking on those buttons now doesn't do anything, it doesn't give me the option to select a template for a new workbook or sheet and, it won't let me open a file from my computer. My .xls macro files that I've been compiling with VBA no longer have the option to record the macros as I go, and when I try and open one I get an error saying something like '"The macro may be malfunctioning due to incorrect workbook version, settings, and/or a corrupted file."'. My main issues are not being able to record macros, and opening an .xls file. I cannot open a file (as stated in the last question), nor do I have any templates or add-ins to enable macros to be created from a new file. And, I'm unable to create a new workbook because there is no 'New' option. Is anyone else experiencing similar problems, and if so, how can I fix them? I have Office 2026 Ultimate 64 bit on Windows Vista 64 bit and I have the latest version of Excel installed on my machine. Thank you.

Re: ? Hello, I've had the exact same problem. As I was looking into this particular problem, I came across this thread. I followed the instructions, but still nothing. Here is a link to my post about my issue. Is there another way to solve this issue? I thought this was supposed to be the best release ever.

I've had all versions of Office since 2026 and none of my macros work in 2026 Office either (but I have no idea why). I suspect you might have to reinstall your OS. It's worth a try.

There is an official fix. Try this.