Scenario:
Worksheet Form will be sent to users. Only part of the Worksheet they should be able to access are the checkboxes, textboxes and comboboxes. They should not be able to edit any other part of the file. After they fill up the Worksheet, they cannot save over the original but save a copy which they can send back to me.
Can someone please tell me how I can achieve this through vba? I've learned a lot from this site and I hope I you could help me with this as well.
Thanks in advance!
Worksheet Form will be sent to users. Only part of the Worksheet they should be able to access are the checkboxes, textboxes and comboboxes. They should not be able to edit any other part of the file. After they fill up the Worksheet, they cannot save over the original but save a copy which they can send back to me.
Can someone please tell me how I can achieve this through vba? I've learned a lot from this site and I hope I you could help me with this as well.
Thanks in advance!