Group outline and protecting worksheet

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

Guest

Is there a way around being able to lock down the work sheet and use the group outline?
 
In code you can enable the outlining before you protect the sheet, in
the following way:

This example enables outlining symbols on a protected worksheet.

ActiveSheet.EnableOutlining = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True
 
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

Using Group and Outline with Protected Cells 1
Protect sheet with outline 1
Lock cells without protecting sheet? 2
Expanding and Collapsing Groups within a Protected Workbook 1
Sharing protected worksheets with outlining 1
Outline using style 1
Excel: Change Direction of Group/Outline Function 3
Grouped Columns/Rows 2

Back
Top