Add new sheets to protected workbook

[mcomp72]

I have a macro-enabled workbook with about 100 users, on both Windows and Mac. I have the workbook protected so they don't accidentally delete or rename a sheet, because doing either would cause the code to no longer work properly. A couple of users have asked me about adding the ability to add a new worksheet. Would it be possible to make the plus button to the right of the sheet tabs (for New Sheet) work without changing the protection on the rest of the workbook?

Also, would it be possible to allow them to change the names of these newly added sheets, but still not allow them to change the names of the existing sheets?

 

[Michael M]

I don't think so....I believe you will need to add some code into your existing macros that asks the user if they want to add a sheet, then un protect, add the sheet and reprotect.....you would then need to ensure you made the new sheet to be incorporated into whatever protections you are applying.
You could also consider only allowing this to happen for certain users....use the Environ(username) for this