I'm hot on Excel functionality but I'm a novice on VB. What I want to do is lockout a cell, but only after allowing input to it once. Eg. Original value of cell is null. Allows input of data once. Cell becomes locked and suppresses any further input to that cell. I appreciate that a user could circumvent the lockout simply by closing the workbook, then reopening it again. However, any ideas would be appreciated.
Ah, actually, there may be up to 10 seoarate cells that would need the same properties. I will put a formula in an adjacent cell (in fact, the formula can go anywhere as long as it refers to the cell in question) which simply checks the value, eg. =if(upper(D5)="CAT","Correct, Well Done!","Wrong. Try Again") The idea is cell D5 will have the lockout function and the user will only have one chance to input a value into that cell. Arghhhhh
Thanks daba. I think your idea could work unless some smarty pants simply explores the menu bar and discovers how to turn off workbook protection. I think it may be possible to use daba's idea with the addition of switching off the menu item for cell protection. Some clever VB would do it. Beyond me however.
As for the menu item to 'unprotect' the sheet, this is circumnavigated by the VBA code locking the sheet with a password (be wary when playing password games in vba, sometimes it can go horribly chest skywards, especially in Excel '97)