using outline(+) button on protected sheet in excel online

[cogswel__cogs]

Hi,
I was hoping to use the outline button to allow users to expand some fields in a spreadsheet on share point.
But the sheet opens in excel online where VBA is not allowed.

The only way I know to use the group(+) on protected sheets is via a macro.

Has this been resolved or addressed on Excel; Online.

If not anyone have a work around for hiding protected data and making it easy to access as well.


Thanks for any help.

 

[Jeffrey Mahoney]

I got around that issues by adding some code into the sheet module. The red portion of the Sheet.protect is what you need. Now, what I assumed was that code would persist if I only ran it once after opening the workbook. I was wrong. If your VBA project gets reset for any reason, it will stop working. So I added it into the sheet module and ran it every time the sheet got activated.

Jeff

Private Sub Worksheet_Activate()
  Dim Sht As Worksheet


Set Sht = ActiveSheet


Sht.Unprotect
Sht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
        , AllowFormattingCells:=True, AllowFormattingColumns:=True, _
        AllowFormattingRows:=True, AllowInsertingHyperlinks:=True, [COLOR=#ff0000]UserInterfaceOnly:=True[/COLOR]

END SUB

 

[cogswel__cogs]

I have similar code but Excel Online does not allow macros

 

[Jeffrey Mahoney]

I have no solution for that!