Protect Worksheet Help!

[lehainam]

Dear all,

I have a workbook of 5 worksheets and I want to protect only Sheet1 &
Sheet2 that user can not delete or change sheet name. Other sheets user
can do anything they want.

Could anyone can help me.

Thanks a lot!

Nam

 

[Guest]

Protecting a sheet does not protect the sheet name. You have to protect the
workbook if you want to protect the name shown on the TAB at the bottom.

 

[lehainam]

Dear Cush,

My question is that user can not delete or change name of sheet1 &
sheet2, the rest can be deleted or changed name and user can add more
sheets.

Thanks,

Nam