It can be done, but to my mind shouldn't be done. Put the following in the
ThisWorkbook module.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Sh.ProtectContents = True Then
If Target.Locked = False Then
SendKeys "{F2}"
End If
Else
SendKeys "{F2}"
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Wuddus" wrote in message
...
Hi--

I work for a publishing company whose editors are really comfortable with
Microsoft Word. They're terrified of Excel and avoid it whenever possible.

I'm trying to sell the benfits of Excel to them, however, and am
rebuilding
a few forms they've clunkily set as Word tables into Excel as a demo. By
way
of trying to mimic Word as much as possible without sacrificing the
benfits
of Excel, however, I was wondering if there's VBA code I can use to change
Excel's single-click function so that, whenever a user clicks on an
unlocked
cell, an editing cursor immediately appears (as opposed to Excel's
default,
where you need to double-click on a cell to to in-cell edits).

Most of the cells (espcially those with formulas) are locked, so that the
only unlocked ones are those calling for text input of one sort or
another.
Is what I want to do even possible?

Thanks for any help anyone can offer!