protection

  • Thread starter Thread starter NV
  • Start date Start date
N

NV

I have set protection on several sheets in a workbook to
control where others can enter data. I set the cursor to
move only to unlocked cells which works fine until I save
it. When I reopen it the cursor can move anywhere in the
sheet but you can only enter data in the unlocked cells.
I have used this before and was able to keep the cursor
from going to the locked cells. Is there a setting that I
am missing?
 
NV,

That Enable Selection doesn't "stick" when you close and reopen the
workbook.
Use this in the workbook_Open Event (modify to suit)

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

John
 
Back
Top