Can I use the grouping and lock and protect cells
 

I want to be able to make some cells so that they cannot be chaned and also
use the grouping?

Hi bfisher

Read this from Dave Peterson

If you protect the worksheet in code, you can do more things
Add this to a general module:

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.)

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"bfisher" wrote in message ...
I want to be able to make some cells so that they cannot be chaned and also
use the grouping?