Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 59
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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
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
Data Entry in shared workbook RUSH2CROCHET Excel Discussion (Misc queries) 0 August 28th 07 09:50 PM
How to hide and secure ranges in worksheet John Excel Worksheet Functions 3 March 28th 07 08:59 AM
Data Entry in a Shared Workbook SueTinkham Excel Worksheet Functions 0 March 28th 07 12:09 AM
Shared Worksheet Parker Excel Discussion (Misc queries) 1 December 17th 04 03:25 PM
Shared worksheet Parker Excel Worksheet Functions 1 December 16th 04 10:44 PM


All times are GMT +1. The time now is 02:30 PM.

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

About Us

"It's about Microsoft Excel"