Forum Discussion
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...
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 :).
I know I don't know anything (Socrates)