SOLVED

Excel M365 Business Basic

Iron Contributor

Does this M365 category support Macro?

 

If yes how? can't see how to enable 

 

This is the only option available

gmj12345_0-1699341507474.png

 

5 Replies

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)

Just clearing simple multiple cells

gmj12345_0-1699356035937.png

 

@LeonPavesic 

 

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 :(

 

 

Hi @gmj12345,

in Microsoft 365 Business Basic, which primarily provides the online (cloud) versions of Excel, you don't have access to the VBA (Visual Basic for Applications) editor or the ability to create and run VBA macros as you can in the desktop Excel version. So, you can't use VBA code to clear a range of cells as you described.

Instead, in the online Excel version, you can achieve the task using different methods:

  1. Open your Excel file in Excel Online.

  2. Select the range of cells you want to clear, for example, A1:A100.

  3. Right-click on the selected range and choose "Clear Content" from the menu.

This action will remove the data from the chosen cells.

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)

best response confirmed by gmj12345 (Iron Contributor)
Solution

@gmj12345 

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 

HansVogelaar_0-1699360682806.png

So the only option is manual clearing.. SAD :(

Thank you all
1 best response

Accepted Solutions
best response confirmed by gmj12345 (Iron Contributor)
Solution

@gmj12345 

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 

HansVogelaar_0-1699360682806.png

View solution in original post