Protect Worksheet Help!
 

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


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=472858

Protect Worksheet Help!
 

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" wrote:


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


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=472858

Protect Worksheet Help!
 

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


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=472858