View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default 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