| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked cells are still able to be selected with proper protection | Excel Discussion (Misc queries) | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Threaded Mode
