in XP, locked cells cannot be selected

[zSplash]

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

 

[Jim Rech]

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

| 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
|
|
|