Forum Discussion
gmj12345
Nov 07, 2023Iron Contributor
Excel M365 Business Basic
Does this M365 category support Macro?
If yes how? can't see how to enable
This is the only option available
As LeonPavesic mentioned, Microsoft 365 Business Basic only lets you use the online (browser) versions of Excel, Word etc.
These versions don't have VBA - you cannot create, nor run macros. That is only possible in the desktop version of Excel, Word etc. for Windows and Mac.
You'll need to subscribe to a different Microsoft 365 plan to be able to download the desktop applications. See Compare All Microsoft 365 Business Plans
- LeonPavesicSilver Contributor
Hi gmj12345,
Microsoft 365 Business Basic primarily offers online (cloud) versions of Office applications (Word, Excel, PowerPoint), and these online versions have limited macro capabilities. They do support some basic scripting and automation features, but the support is not as extensive as what you find in the desktop versions of Office applications.
If advanced macro functionality is crucial for your needs, you might need a higher-tier Microsoft 365 subscription that includes the desktop versions of Office applications, which provide more robust support for macros, such as VBA (Visual Basic for Applications).
Compare Microsoft 365 Plans | Microsoft 365
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)- gmj12345Iron Contributor
Just clearing simple multiple cells
How to do that in M365 Business Basic - Excel
Range("A1:A100").Clear
I am looking for where to insert this code since when I press ALT+F11 no macro window that shows 😞
As LeonPavesic mentioned, Microsoft 365 Business Basic only lets you use the online (browser) versions of Excel, Word etc.
These versions don't have VBA - you cannot create, nor run macros. That is only possible in the desktop version of Excel, Word etc. for Windows and Mac.
You'll need to subscribe to a different Microsoft 365 plan to be able to download the desktop applications. See Compare All Microsoft 365 Business Plans