in XP, locked cells cannot be selected
 

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

in XP, locked cells cannot be selected
 

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