Hi everyone
I'm trying to setup a spreadsheet where after typing in the name and selecting all the fees it would automatically lock the column
so the user wouldnt be able to go back and change the name or the fees again after inputing them for the first time.
So lets say i type new name in A3, I select all the fees i want to then i proceed to A4 with a different name, and at this point I should be unable to change anything in A3 but
the program wouldn't lock me out from inputing other users in other columns until they filled.
I found a bunch of other similar topics on that subject like :
http://www.excelforum.com/excel-prog...ific-cell.html
http://www.excelforum.com/excel-prog...a-entered.html
But the only problem I have with those solutions is that they are locking down the rows as well.
Any idea how can i lock them ?
I've attached the spreadsheet to the post if you want to have a look
Any help would be appreciated.
Cheers
Bookmarks