group rows

  • Thread starter Thread starter greg
  • Start date Start date
G

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
 
Hi
what Excel version are you using. Starting with Excel 2002? you can
allow grouping in the protection dialog
 
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
 
Hi
within the dialog 'Tools - Protection - sheet' should be a checkbox to
allow grouping
 
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
 
hey, pretty cool.
thanks


Dave Peterson said:
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
Click to expand...
 
Back
Top