Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|