| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
| protect worksheet | Excel Discussion (Misc queries) | |||
| How can i protect worksheet until a value is placed in a certain c | Excel Discussion (Misc queries) | |||
| worksheet protect | Excel Worksheet Functions | |||
| How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
![lehainam[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
