Thanks again, Paul.

I understand your suggestion on using macro as the option to lock data and I will try and explore the option. However, as I've told you earlier, most of the clients will face security issues in their internal systems due to the macro enabled document. Maybe the drop down can be a replacement for it.

is there as macro free way to ensure that the users complete all fields in the form?

Thanks.