Protecting ONLY ONE sheet

[Zahhhaaaa]

I have sheet named "Default", and many many other sheets in workbook. Is there a code to protect ONLY this "Default"-sheet so that no one else can't change it but me. I'd like to prevent users to rename or delete it.

I've tried to protect sheets and workbook but it wont work. Default-sheet includes Textboxes etc and even when I protect sheet, user is still able to write on textbox.

 

[Ruddles]

Yes, you can protect just a single sheet, or even part of a sheet.

Did you format the cells as Locked?

 

[Zahhhaaaa]

Yeah, they're locked. Point is that this "Default-sheet" is blank, there are comboboxes, textboxes etc. User copies this sheet using macro, new sheet is named after specific date and then user can change values in this copied sheet. And after user has done wanted changes, he selects "new sheet", and new sheet appears and is named after specific date, a blank copy of "Default-sheet".

I want this "Default-sheet" to be protected in any way, text cannot be inserted in textboxes (when I select protect sheet, I still can write on textbox), etc.

The real problem is that when default-sheet is protected and I copy it, this new copy is also protected same way, is it possible that when new copy of default-sheet is inserted, it automatically unlocks protection? So that user doesn't have to select unlocking manually every time default-sheet is copied.