Many Thanks Debra,
No i didn't protect the sheet programatically, i only locked the sheet by
using the protect sheet under the tools menu.
Thank you in advance for your help, and to you Frank.
"Debra Dalgleish" wrote:
> If you protect the worksheet programmatically, you can enable outlining,
> and you will be able to use the groups that you have created.
> The following code goes in the ThisWorkbook module:
> Private Sub Workbook_Open()
> With Worksheets("Sheet1")
> .EnableOutlining = True
> .Protect Password:="password", _
> Contents:=True, UserInterfaceOnly:=True
> End With
> End Sub
> To paste the code into the ThisWorkbook module:
> Right-click on the Excel icon, to the left of the File menu
> Choose View Code
> Paste the code where the cursor is flashing.
> Fadi Haddad wrote:
> > 1 -I have grouped data in my excel sheet by using the Group rows function.
> > 2- When i protect the sheet, the goup and Ungroup button (the + sign at the
> > left of the sheet), won't work.
> > Question:
> > Is there a way to proctect the sheet and keep the Group and ungroup (+
> > sign)function normally.
> > Thank you
> Debra Dalgleish
> Excel FAQ, Tips & Book List