Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
CAN SOMEONE HELP ME TO PREPARE A WORKSHEET WHEREIN ;;;
1. DATA VALIDATION BY LIST OR CUSTOMS IN F2:F1000 2. AUTO ENTRY OF DATE n NAME WILL BE FILLED IN G2:G1000 - TO SHOW DATE [NOW() OF ENCODING and THE ENCODER NAME. 3. UPON SAVE/CLOSE = F:G with encoded data and date will be freezed or locked. SO that when the file will be opened again, any other encoder cannot commit a mistake to change the previous encoding. i HOPE THIS IS POSSIBLE AND NOT VOLATILE....thanks -- "Bright minds are blessed to those who share them.."-rsb. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |