View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] goodlucksspl@gmail.com is offline
external usenet poster
 
Posts: 1
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


Dear Sir,

I want to lock the cells after editing couple of ranges. is it posible to lock the cell after edit the range i.e. A:A. and locked the cell after 2 hours automatically.