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?