#1
|
|||
|
|||
Have a very specific requirement
In our work, we came up very specific functional requirement for excel spreadsheet we maintain. We need one of the column to have following properties: - All cells in the column must have unique values (will use some mathematical hash function to do it, so this is not core of question here) - Only empty cells in this column can be edited and it can be edited only once. - Once it has value, it can not be edited at all. Not under any circumstances. Is it possible, does it need VBA programming or can be accomplished without programming? Thanks., |
#2
|
|||
|
|||
NOTHING???? No-body has clue?
|
#3
|
|||
|
|||
Quote:
Then use the Worksheet_Change event to lock empties as used. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add buttons for specific document? | MAtkins | Word | 3 | 10-10-2016 11:20 AM |
Print attachment when it arrive in specific folder with specific subject | visha_1984 | Outlook | 1 | 01-30-2013 10:42 AM |
Specific Hyperlink | dextrousdave | Word | 1 | 01-16-2012 09:10 PM |
Looking for a specific spreadsheet | DivideByZer0 | Excel | 3 | 11-10-2009 05:58 PM |
automatic requirement numbering with change detection | stijnos | Word | 0 | 05-13-2009 12:10 AM |