Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old December 1st 14, 10:11 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2014
Posts: 2
Default Lock Cell After Data is Entered on Particular Cell

On Sunday, June 24, 2012 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 all,

i want to lock the excel spread sheet after cell entry , (lock the cells one by one )

  #12   Report Post  
Old December 30th 14, 07:44 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2014
Posts: 2
Default Lock Cell After Data is Entered on Particular Cell

On Sunday, June 24, 2012 7:38:06 PM UTC+5:30, Gord Dibben wrote:
First...........select all cells on sheet and format them to unlocked.

Add this event code to the worksheet module.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 3 Then
ActiveSheet.Unprotect Password:="justme"
n = Target.Row
If Me.Range("C" & n).Value < "" Then
Me.Range("C" & n).Locked = True
End If
End If
enditall:
ActiveSheet.Protect Password:="justme"
Application.EnableEvents = True
End Sub

When you enter a value in column C that cell will become locked for
editing.


Gord


On Sun, 24 Jun 2012 12:00:21 +0000, 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


Thanks , i need one more clarifications. once entered the data in cell give the lock of each column respective row.

if possible please post.

thank you for the support
  #13   Report Post  
Old December 10th 16, 07:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 1
Default Lock Cell After Data is Entered on Particular Cell

i want cell lock after input automatically in google drive....

can any one send the process....


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re : How to lock a cell once the value is entered Andy Excel Worksheet Functions 2 June 22nd 09 08:44 PM
LOCK CELL AFTER DATA IS ENTERED MIke Excel Discussion (Misc queries) 4 October 24th 07 12:33 AM
Lock Data in Cell after entered CrimsonPlague29 Excel Discussion (Misc queries) 0 May 9th 06 11:51 AM
How do I lock a cell automatically after it has data entered. Dandy Excel Discussion (Misc queries) 0 March 30th 06 12:39 PM
how can i lock cell immediately if any value Entered? Sureshsmartdc New Users to Excel 2 August 20th 05 11:05 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017