protecting outlined data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to use the expand/collapse function in outlines when the worksheet is protected.
 
Copy this macro in a normal module

It will run automatic when you open the workbook
You can also use the workbook open event

Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="rbelecki", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

Look in the VBA help for more information about protect(userinterfaceonly)
 
Back
Top