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

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
168
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.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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

Code:
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top