Select Locked Cells (Excel 2002)

Topic

New Reply

I use the following code to protect my worksheets:

For i = 1 To Worksheets.Count
Worksheets(i).Unprotect Password:=strPasswd
Next i

My problem is that the user can still select locked cells even though he can

Reply | Quote

Replies

Hi Jim

When protecting the sheet add the following line.

Worksheets(i).EnableSelection = xlUnlockedCells

Reply | Quote

Perfect Tony! In an early post, I think it was your code I found to protect worksheets but didn’t know how to lock the cells. I appreciate your help!

Reply | Quote

Perfect Tony! In an early post, I think it was your code I found to protect worksheets but didn’t know how to lock the cells. I appreciate your help!

Reply | Quote

Hi Jim

When protecting the sheet add the following line.

Worksheets(i).EnableSelection = xlUnlockedCells

Reply | Quote