Daily tips for using Microsoft Excel.

Tuesday, February 12, 2002

Anthony asks "When selecting the '0 -xlUnlockedCells' properity in the EnableSelection
window only the unlocked cells can be selected when the workbook is
protected. However, when the workbook is Saved, Closed and then re-opened
the EnableSelection defaults back to '0 -xlNoRestrictions' how can I stop
this happening

Regards"


Well, this can be solved using some events. One, using the Workbook_Open event, or two, using the Sheet_Activate event, like this:

In the workbook Module

Private Sub Workbook_Open()
Sheets("Sheet1").EnableSelection = xlUnlockedCells
End Sub

or in the Sheet's Module

Private Sub Worksheet_Activate()
ActiveSheet.EnableSelection = xlUnlockedCells
End Sub

One final thing, xlUnlockedCells equals 1, not 0. 0 is xlNoRestrictions and -4142 is xlNoSelection.