Protect Worksheet Help!

  • Thread starter Thread starter lehainam
  • Start date Start date
L

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
 
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.
 
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
 
Back
Top