Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-02-2017, 12:05 PM
ggoffice000 ggoffice000 is offline Have a very specific requirement Windows 10 Have a very specific requirement Office 2016
Novice
Have a very specific requirement
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Have a very specific requirement 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
Have a very specific requirement Specific Hyperlink dextrousdave Word 1 01-16-2012 09:10 PM
Have a very specific requirement 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft