Can I use the grouping and lock and protect cells

B

bfisher

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

Ron de Bruin

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
 
Top