Hi,

I have a number of worksheets that I wish to protect to content of but I also want users to be able to group/ungroup rows and columns as well as format the cells (i.e. change the number of decimal places a number is shown to).

My current code does the following to lock each sheet

ActiveSheet.Protect Password:="Password", DrawingObjects:=False, Contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowFiltering:=True


However I don't seem to be able to add any form of EnableOutlining to this without it refusing to work!
Is there any way to combine the two codes?