Lock Cell After Enter Command
If the routine that Gord provided started with
Sub Worksheet_...
or
Private Sub Worksheet_...
Then it goes into the worksheet area which is easily accessible: right
click on the worksheet's name tab and click the [View Code] option in the
list. Copy and paste the code into the module that appears.
"DOUG" wrote:
Is there a way to lock a cell in a shared workbook after the user has made an
entry? I did view Gordon Dibben's response to Casey on 9/23/07. It was
similar to what I am trying to do, but I did not understand where to place
the code in VBA.
DOUG
|