Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes, but only with VBA and a Protected Worksheet.
The code for this is available. Questions................. 1. You say users fill out a "row of data"...................how many columns would that row contain? e.g. A to F or ?? 2. Do users fill out all cells in that row's range? Gord Dibben MS Excel MVP On Wed, 19 May 2010 13:05:01 -0700, Jessica wrote: I have a spreadsheet that will be accessed by multiple users. Each user will fill out a row of data, save and close the spreadsheet. We do not want users to edit rows after data is entered into a row of cells. Is there any way to lock this data to prevent it from being edited? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I lock a cell after data entry so entry can not be changed | Excel Discussion (Misc queries) | |||
Lock out data entry in a cell | Excel Discussion (Misc queries) | |||
Lock Data in cell after data entry | Excel Discussion (Misc queries) | |||
Lock Cell After Data Entry | Excel Discussion (Misc queries) | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel |