Change default for protected sheets
 

The default is set at being able to access both locked and unlocked cells

How can I change this to allow access to only unlocked cells, without having
to unclick that option each time?

thanks

Change default for protected sheets
 

Create a new workbook. Under worksheet protection deselect locked files.
Save this workbook with the name Book as a template in C:\Documents and
Settings\<username\Application Data\Microsoft\Excel\XLStart. Restart Excel.
Excel will now use the workbook as the template for all new workbooks. You
can use the same technique for worksheets as well. Just create a new
workbook with only 1 worksheet. Make whatever changes you want to the
worksheet and save the workbook as a template with the name Sheet. Restart
Excel. All new worksheets will now use the saved template.

Tyro

"carrera" wrote in message
...
The default is set at being able to access both locked and unlocked cells

How can I change this to allow access to only unlocked cells, without
having
to unclick that option each time?

thanks

Change default for protected sheets
 

I just added a couple of buttons to a Toolbar and assigned these macros.

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 MS Excel MVP

On Thu, 10 Jan 2008 09:26:07 -0800, carrera
wrote:

The default is set at being able to access both locked and unlocked cells

How can I change this to allow access to only unlocked cells, without having
to unclick that option each time?

thanks

Change default for protected sheets
 

Correction: locked files should be locked cells

Tyro

"Tyro" wrote in message
et...
Create a new workbook. Under worksheet protection deselect locked files.
Save this workbook with the name Book as a template in C:\Documents and
Settings\<username\Application Data\Microsoft\Excel\XLStart. Restart
Excel. Excel will now use the workbook as the template for all new
workbooks. You can use the same technique for worksheets as well. Just
create a new workbook with only 1 worksheet. Make whatever changes you
want to the worksheet and save the workbook as a template with the name
Sheet. Restart Excel. All new worksheets will now use the saved template.

Tyro

"carrera" wrote in message
...
The default is set at being able to access both locked and unlocked cells

How can I change this to allow access to only unlocked cells, without
having
to unclick that option each time?

thanks