View Single Post
 
Old 02-02-2017, 12:05 PM
ggoffice000 ggoffice000 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2017
Posts: 2
ggoffice000 is on a distinguished road
Default 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.,
Reply With Quote