Hi guys, I'm new in Excel VBA coding, I would like to make the data unchangeable after save. And now I need to create a macro that the cell will be protected and locked after the data entry. Only some of the cell can be enter the data while most of other cell have been protected and locked already. Please help me....
You would need to use VBA to do that. You'd have a Worksheet Change event monitoring the cells of interest and, after the data has been entered, you'd have to set the status of the cell to "locked". For that to work, the sheet would have to be protected.
Sounds a bit dangerous though. It assumes that the correct data will be entered first time ... there will be no opportunity to change it.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the reply~. However, its that possible to be done through VBA code.
Actually my condition is like this. I have a template which has text in some cells and some cells are blank, i have lock the cells which has text and keep the blank cells unlocked for user input. After the user input, i need to lock also the cell which the data have been entered. Its that possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks