group rows

[greg]

hello,
i have a question about grouping rows.
I have protected my worksheet. With some cells un-protected (Format cellsi have grouped several rows.
But once i protect the worksheet, i canoot expand/shrink my group.
is there a way to have protection on but still allow use of the grouping?

thanks in advance

 

[Frank Kabel]

Hi
what Excel version are you using. Starting with Excel 2002? you can
allow grouping in the protection dialog

 

[greg]

Hello, thanks for the comment.
I have excel 2002 sp2.
I can group. but when I protect the sheet, i can no longer use the "plus"
sign to open close it.

is there something i need to set to make it work?
like un-protecting cells (Format cells >> protection, un check lock)

thanks in advance

 

[Frank Kabel]

Hi
within the dialog 'Tools - Protection - sheet' should be a checkbox to
allow grouping

 

[greg]

thank you for the help.
I do not see a checkbox for grouping in either 2002 or 2003

 

[Dave Peterson]

If you already have the outline applied, you can protect the worksheet in code
(auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

(you could use the workbook_open even under ThisWorkbook, too.)

Don't forget to lock the VBA Project, too. Else you'll have inquisitive types
looking at your code and seeing the password.

Inside the VBE, you can lock the project.
Tools|VBAProject Properties|Protection tab.
Give it a memorable password and lock the project for viewing.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[greg]

hey, pretty cool.
thanks

If you already have the outline applied, you can protect the worksheet in code
(auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

(you could use the workbook_open even under ThisWorkbook, too.)

Don't forget to lock the VBA Project, too. Else you'll have inquisitive types
looking at your code and seeing the password.

Inside the VBE, you can lock the project.
Tools|VBAProject Properties|Protection tab.
Give it a memorable password and lock the project for viewing.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm