Workbook structure protection for opnly specified sheets

Hi,

Is it possible to allow the user to add/delete/rename only certain sheets and have workbook structure protection on other sheets? I want the user to be able to add/delete/rename whatever sheets he/she adds themselves, but prevent the user from renaming/deleting just three tabs I created.

Lawrence

Hi Lawrence,

I don’t think we can protect structure for selected sheets and leave the rest. However, I would love to see some comments from the experienced team too



Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **

with VBA you can use the CodeName for the Sheet to rename it if they've changed it in a Workbook_BeforeClose routine.

You can use a Workbook_BeforeSave routine to cancel saving if the 3 specific sheets do not exist. and provide a message box that the file will not be saved because they jacked with it.