Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shared Worksheet--secure last entry
ood morning,
We are doing a survey through excel 2003 where about 50 people are answering a question on a shared workbook. Our concern is that one person would cast their vote, only to be change dlater by someone else. Is there any way to "lockdown" a cell once it is filled in with text? The column they answer in is A. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shared Worksheet--secure last entry
I just found this code on the DGs yesterday. Maybe it will be of some use to
you: Private Sub Worksheet_Change(ByVal Target As Range) Dim myRow As Long Dim myVal As Variant If Target.Cells.Count 1 Then Exit Sub With Application ..EnableEvents = False ..ScreenUpdating = False myVal = Target.Value ..Undo myRow = Sheets("History Sheet").Cells(Rows.Count, 3).End(xlUp)(2).Row Intersect(Target.EntireRow, ActiveSheet.UsedRange).Copy _ Sheets("History Sheet").Cells(myRow, 3) Sheets("History Sheet").Cells(myRow, 2).Value = Now Sheets("History Sheet").Cells(myRow, 1).Value = .UserName Target.Value = myVal ..ScreenUpdating = True ..EnableEvents = True End With End Sub To use: copy the code, right-click your sheet, and paste the code into the window that opens (into the VBE). Regards, Ryan--- -- RyGuy "nabanco" wrote: ood morning, We are doing a survey through excel 2003 where about 50 people are answering a question on a shared workbook. Our concern is that one person would cast their vote, only to be change dlater by someone else. Is there any way to "lockdown" a cell once it is filled in with text? The column they answer in is A. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry in shared workbook | Excel Discussion (Misc queries) | |||
How to hide and secure ranges in worksheet | Excel Worksheet Functions | |||
Data Entry in a Shared Workbook | Excel Worksheet Functions | |||
Shared Worksheet | Excel Discussion (Misc queries) | |||
Shared worksheet | Excel Worksheet Functions |