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
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.
"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
>
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks