Subtotal issues with protection

**bgreen** · 06-02-2009, 09:42 AM

Hello - I have a pretty straight forward spreadsheet that I want to keep protected so no one can adjust formulas or anything else, however, it is a large list of items that I have subtotaled. I do want the end user to have the ability to expand and contract the subtotal sections but it won't let them once the sheet is protected. Any thoughts on how I can accomplish this?Thanks!
Matt

**JONvdHeyden** · 06-02-2009, 10:04 AM

You need to protect it with code, something like:

 
With ActiveSheet
    .EnableOutlining = True
    .Protect contents:=True, userInterfaceOnly:=True
End With

**bgreen** · 06-02-2009, 11:11 AM

Thanks for the assistance. I added the code to the VBA Code section for that sheet and then locked the sheet, but am getting the same errors. Could you provide some direction on exactly where I enter the code and anything I might be doing wrong?

Thanks!
Matt