Forum Discussion

gmj12345's avatar
gmj12345
Iron Contributor
Nov 07, 2023

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

 

Admin
Excel
office 365
Office Scripts
  • HansVogelaar's avatar
    HansVogelaar
    Nov 07, 2023

    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 

  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor
    Nov 07, 2023

    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)

    • gmj12345's avatar
      gmj12345
      Iron Contributor
      Nov 07, 2023

      Just clearing simple multiple cells

       

      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 😞

       

       

      • LeonPavesic's avatar
        LeonPavesic
        Silver Contributor
        Nov 07, 2023

        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)

Share

Resources