| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel sheet
Hi,
Kindly assist. I have scenario where I have 4 columns (B3, C3, D3, E3 )in the excel sheet. I would like to stop the user once he has keyed information in any of these cells. thanks TJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel sheet
Click on B3 and:
Data Validation Settings Allow Custom =COUNTA($B$3:$E$3)<2 Then copy B3 to C3 thru E3 -- Gary''s Student - gsnu200846 "TJ" wrote: Hi, Kindly assist. I have scenario where I have 4 columns (B3, C3, D3, E3 )in the excel sheet. I would like to stop the user once he has keyed information in any of these cells. thanks TJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create Login & Log out Spread sheet in Excel with automated Attendance sheet | Excel Worksheet Functions | |||
| Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Linear Mode
