Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 02-03-2017, 03:24 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

NOTHING???? No-body has clue?
Reply With Quote
  #3  
Old 02-03-2017, 03:47 PM
NoSparks NoSparks is offline Have a very specific requirement Windows 7 64bit Have a very specific requirement Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
Not under any circumstances.
Excel is not that secure, but you could try locking all but the empty cells in the column and using a password.
Then use the Worksheet_Change event to lock empties as used.
Reply With Quote
Reply



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 07:11 AM.


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