It seems to be a workbook option and is saved with that workbook and not
respected by other workbooks, new or existing.
For all new workbooks I would suggest creating a new default Template to replace
the Excel default workbook.
Before saving as a Template, set Tools>Protection>Protect Worksheet options as
you like.
Save as an excel workbook.xls
Unprotect the worksheet then save as a a Template named BOOK.xlt
File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.
Store this workbook in the XLSTART folder usually located at........
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
This will be the default workbook for File>New or the Toolbar button File>New or
CTRL + n
If you want the Excel default workbook go to File>New...Blank Workbook.
NOTE: Existing workbooks are not affected by these settings.
You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.
More can be found on this in Help under "templates"(no quotes).
Or dispense with all the above and protect the sheet using a macro.
Sub SHEETPROTECT()
With ActiveSheet
.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
.EnableSelection = xlUnlockedCells
End With
End Sub
Sub SHEETUNPROTECT()
ActiveSheet.Unprotect Password:="justme"
End Sub
Gord Dibben Excel MVP
