Protecting worksheet vs workbook

Yes, there is most definitely a way to do this and I'll tell you how... Also, I don't know if bumping is against the rules, but I just did it 3 times on my post lol... I think the community is mad at me bc I don't contribute much, so I'm gonna try to contribute more.

OK, so to allow users alter cells on a protected worksheet go to the Data tab, go to "Allow Users to Edit Ranges", then hit "New".. You should be able to get it from there.

To protect the worksheet with a password, go to Data tab, click on protect worksheet and type in the password you want to use.

If you protect the worksheet/workbook, they shouldn't be able to make any changes to your code.

Hope this helps!

Thanks for the reply.

The worksheets are already protected - this allows the normal users to enter data into the designated entry cells (by unlocking those cells) and it allows the maintaining user to unprotect the worksheet and make any changes to the forms as required - this includes creating/deleting worksheets and editing the VB code. This works as I want it to.

I want to create an 'about' worksheet (or text box) which can not be edited, moved or deleted in any way by anyone. This can be achieved by protecting the whole workbook with a password (but this then prevents and creating or deleting of all worksheets - which prevents the maintaining users performing important functions).

I'm wondering if there is a way to protect the 'about' worksheet from deletion without affecting all the worksheets in the file (protecting individual sheets doesn't prevent deletion).