Forum Discussion

cheeseontoast101's avatar
cheeseontoast101
Copper Contributor
Apr 17, 2022

How to use group/ungroup in protected sheet without vba - excel online

Hi

 

I have a spreadsheet which needs to be shared by others over share point. Unfortunately, the risk of the formulas being accidentally altered is too high high and it must be protected otherwise the data will be compromised.

 

This data also needs to be grouped into sections as there is too much of it.

 

I understand you can do this with VBA but obviously the developer tab is not available online - is there any other work around, trick, hack for this?

 

 

Excel for web
Formulas and Functions

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 18, 2022

    cheeseontoast101 

    Here's a small Solution approach...

    Please replace "MyTable Sheet" with the name of your Excel sheet and assign a password to remove the protection.

     

    Private SubWorkbook_Open()

     Sheets("MySheet").Protect Password:="MyPassword", UserInterfaceOnly:=True
     Sheets("MySheet").EnableOutlining = True

     End sub

     

     Please note that the macro will be completed in a different version of Excel, as macros can be run online in Excel but not created (to put it in simple terms).

    Work with VBA macros in Excel for the web

    Save the Excel file as a macro file (.xlsm) or binary file (.xlsb) to keep the macros.

     

    Additional Information:

    Outline (group) data in a worksheet

     

    Hope I was able to help you :).

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources