Can I change default check boxes on protect sheet?

[DWAyers]

When I choose the menu under Tools for Protectsheet, I would prefer that the
check box for "Select Locked Cells" always be blank. Is there anyway to set
this as my default?

 

[Gord Dibben]

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