Grouping while Sheet protected

  • Thread starter Thread starter Barney Quinn
  • Start date Start date
B

Barney Quinn

Is there any way of allowing users to a shared worksheet to use the grouping
feature for my columns while the sheet is protected?

B
 
Because you can't change the protection in a shared workbook, you won't
be able to use the grouping feature on a protected sheet.

In a workbook that isn't shared, you can run a macro as the workbook
opens, to apply protection and allow grouping. Here's some sample code
posted by Dave Peterson:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
 
Back
Top