Feb 18 2019 04:03 AM
I have a document with several editors who should be allowed to input data.
All those individual editor spaces come together in a 'summary' page which i want to protect from being edited. However, I want 'viewers' to be able to expand the rows (groups) so they can SEE the data, just not edit it (unless doing so on the appropriate tab)
Is this possible...... grouping available on a protected sheet.
Or should I protect some other way, lock particlar cells... any suggestions welcomed.
Feb 18 2019 04:21 AM
SolutionAs far as I'm aware you need to use VBA to do this using Sheet.EnableOutlining = True
Right Click on your summary tab and select View Code
Then paste this code in the window
Private Sub Worksheet_Activate() With ActiveSheet .Protect Password:="XYZ", UserInterfaceOnly:=True .EnableOutlining = True End With End Sub
This code could be put in a workbook open event or wherever is suitable.
Feb 19 2019 07:37 AM
Firstly, thanks so much for the answer given. it helped in part.
Having done this, I now find when I go back to the document after closing, the changes are not saved. If I 'view code' I see the changes are still there, but 'enable outlining' has reverted back to false.... So now, I can no longer expand the rows because they are protected. To do this, I have to 'view code' and save every time I want to open the document again.
What am i doing wrong please!?!??
Feb 19 2019 02:59 PM
Feb 18 2019 04:21 AM
SolutionAs far as I'm aware you need to use VBA to do this using Sheet.EnableOutlining = True
Right Click on your summary tab and select View Code
Then paste this code in the window
Private Sub Worksheet_Activate() With ActiveSheet .Protect Password:="XYZ", UserInterfaceOnly:=True .EnableOutlining = True End With End Sub
This code could be put in a workbook open event or wherever is suitable.