THANK YOU! Its a great help

"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
> http://www.contextures.com/tiptech.html
>
>