Why macro is not working in Office 365?

Are macros disabled by default in Office 365?

Is the default for Office 365 to have no macros, or are you able to enable them.

I know there is a setting in settings, but I can't find a way to see what it does.

In most cases the answer is yes. But you can add an exception. From my experience, people who really need to enable them tend to have a need, so they do it themselves, using the macro security dialog. I'm not sure if this is a documented setting.

Go to "Settings"->"Security" and click "Access options". If you find your setting, click on it, and then "View details" to the right.

How to enable macros in 365 Excel?

For those of you who don't know, the 365 Macros project is a wonderful collection of Excel workbook templates for various business areas including Marketing, Sales, Human Resource, Accounting, Inventory, Product Planning, Customer Service, etc.

They are organized in categories and there are 365 subcategories in each category. There are many different templates for different kinds of use cases. I did try one day for fun, but got stuck at an error which only happened to the template that I wanted. I do not want to spend days looking for some solutions if I know there are easy ways to solve it. Then I discovered some tips that really surprised me. Here is what I found out.

Download from here. You may save your downloaded file in any folder to access it later.

Click the first file Sofia.xltm in order to add a new project to your Excel workbook.

Open Sofia.xlsm to view all the templates. I find it hard to find the Macro button. However, click on More on the top right corner of the window. A menu will appear.

You will see that the file has macros with a list of macros that you need to select. Select the macro(s) you need to activate and click OK to run it. For example, in Sofia.xlsm, you may see something like this: This means that you have 4 macros in your workbook. Go to Tools > Macro > Edit Macros, and you will find them all there.

Note that some categories or subcategories have less templates and therefore less macros. This is why you may not see a list of macros. It is not hard to search for macros. For example, in Customer Service - Marketing Plan you will see lots of templates and may wonder how you are going to find a macro to create one for you. It is very easy, just go to Excel > VBA Editor > Macros to open the Macro window. There you can select a template from many other subcategories.

Why macro is not working in Office 365?

I am new in this topic and I have recently encountered a strange issue with our Outlook 365 deployment.

All our users are configured to run macros on every mail when they open it, even though we enabled macro-enabled on certain messages in the exchange portal as suggested here: However, macros are not working in office 365. When we open mails from the outlook web access they dont work as expected. Mails sent from our office email clients work perfectly fine. We have tried enabling the macro option for some of the mails but still its not working. We tried with outlook 2026, 2026 and 2026 and same issue occurs.

Is there any way to debug the issue and figure out which email properties are causing the macro to not be enabled? Update 1. Macro work if I open the message using the microsoft web app. Update 2. It seems like macro is not available only for Exchange Online or it is supported only with the standard Exchange mailboxes. I don't know the exact details of Office 365. Can anybody clarify?
Office 365 is a hybrid cloud platform. While it uses Office 365 for user mailbox and messaging, other applications like Office Web Apps, Yammer, and Skype for Business Online, etc. Use a combination of on-premises Exchange servers and Office 365 services. The macro feature is a bit of a hybrid: it has a hybrid application mode, which enables you to develop and execute macros in the cloud via the Office Developer Experience (ODX) service, and a hybrid deployment mode, which enables you to enable macros for emails hosted on-premises and/or on Office 365 services. This article explains it in details.

To enable macros on emails that are hosted on-premises, you can set up the Exchange hybrid deployment mode, and create a custom rule in the Exchange Management Shell to determine when the deployment mode should be switched on. Then you need to add the macro-enabled properties in the recipient's folder.

To enable macros on emails hosted on Office 365, you can use a custom workflow in the OWA, which will switch the deployment mode to hybrid when the workflow runs.