Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
all above entered first
Is there a way to lock out cells without a lot of vba code; maybe with
none at all? For example, insist column data entry is allowed only in order, with no empty cells allowed. In a column, row 1 would have to contain data before row 2 was unlocked. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
all above entered first
cate submitted this idea :
Is there a way to lock out cells without a lot of vba code; maybe with none at all? For example, insist column data entry is allowed only in order, with no empty cells allowed. In a column, row 1 would have to contain data before row 2 was unlocked. Thank you. Not without using a VBA event procedure. In this case your code can insert the next row when required input is satisfied for the current row. All unused rows are locked and sheet protection applied so users can only access input fields. <Non-VBA alternative You could use ConditionalFormatting to create the 'illusion' that row2 doesn't 'appear' until all required data is entered in row1. This would require some hidden helper columns, but no VBA is needed. Effectively, rows will continue to 'appear' as the current row data input completes. In this scenario there is no sheet protection used. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
formula cant be entered | Excel Discussion (Misc queries) | |||
Value must be entered | Excel Discussion (Misc queries) | |||
No value entered | Excel Worksheet Functions | |||
How to get last entered value in a ROW? | Excel Programming |