Is there some way to get around XP's restriction from "clicking on" locked
cells?

What Excel 2002 restriction is that? While you cannot edit locked cells in
a protected sheet you can select them (unless you've taken specific steps to
prevent it).

--
Jim Rech
Excel MVP

"zSplash" wrote in message
...
| Is there some way to get around XP's restriction from "clicking on" locked
| cells? To turn checkmarks on and off in Win2k, I run the following code
on
| locked cells, but I get an error when I attempt to run the code in Office
| XP.
|
| Sub toggleCheckmark()
| If ((Target.Column 8 And Target.Column < 15)) Then
| If Range("G" & Target.Row) = "" Then
| Range(Target).Value = ""
| Else
| If Range(Target).Value < "" Then
| Range(Target).Value = ""
| Else
| Range(Target).Value = Chr(252)
| End If
| End If
| End If
| End Sub
|
|
|