View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Faizan Khan Faizan Khan is offline
external usenet poster
 
Posts: 2
Default Lock Cell After Data is Entered on Particular Cell

On Sunday, June 24, 2012 at 5:30:21 PM UTC+5:30, Moideen wrote:
We are maintaing an excel sheet for expense details, After Entering the
data on Amount Coloumn Need to Lock The Amount Coloumn with Password.
Please help me.

Coloumn 1 Coloumn 2 Coloumn 3

Date Item Name Amount




--
Moideen



Hi Guys,

This code works fine.

But I need to lock cell whenever it gets edited.

for example if I edit A1 than after editing A1 needs password to edit again similarly to other cells.