Hoping someone can help me with this. I am developing a CRM system for my organisation. I've added a macro that means a data entry form pops up when you push a button on the sheet, and users can input a new contact here or log a new interaction.
However, I am struggling to find a way to lock the tables these forms feed into without also locking the form. I want people to be able to add 'New' in the form, but not delete anything or edit formatting on the sheets. Every time I try to protect the sheet, the form becomes unusable.
Can anyone help?
tldr: how to unlock a data entry form but lock the table it feeds into