Protected and locked after the data entry using VBA code

  • Hi guys, I'm new in Excel VBA coding, I would like to make the data unchangeable after save. 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 before close the workbook. Its that possible?

  • Re: Protected and locked after the data entry using VBA code


    Found this in my notes (comes from somewhere in the web), should do what you need. Copy it in the ThisWorkBook code module:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!