protecting spreadsheet (2000/2003)

Topic

New Reply

Hello,

I am creating a vb macro to protect a worksheet except for two cells (a21, f27). I would like the user to be able to only go to those to cells once the worksheet open. Any help would be great?

Reply | Quote

Replies

You can use code like this:

With ActiveSheet ‘ or Worksheets(“MySheet”)
.Range(“A21,F27”).Locked = False
.Protect
.EnableSelection = xlUnlockedCells
End With

Reply | Quote

Thanks Hans for the quick response.

Reply | Quote