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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect worksheet but expand and collapse outline? 1
Outlining on a protected spreadsheet 1
Group and Outline on a Protected Sheet 14
Sheet protection and "Group and Outline" 8
excel outlines structure 3
Word The More add-in for Microsoft Word 0
How do I remove the outline protection in Excel sheet? 1
How to hide outline navigation panel 5

Back
Top