Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Excelsheet
Hi, i am using Excelsheet in my application. Due to some security reasons i made it as protected one. if i use mouse to select cells it is working fine.but i use down and up arrows to select cells it is giving not responding and taskmanger is showing 100% cpu usage. i am using Excel2003. Can anybody send me how to protect only one row and not effect to other rows? Thanks, Guru -- ngmahesh ------------------------------------------------------------------------ ngmahesh's Profile: http://www.excelforum.com/member.php...o&userid=30182 View this thread: http://www.excelforum.com/showthread...hreadid=498669 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Excelsheet
Hi, I guess you would have to select everycell on the sheet by clicking the top left corner then right click in the highlighted area, then select FORMAT CELLS, and then choose PROTECTION, click the LOCKED button until it shows empty i.e no tick or shading, then select the row you want to protect then right click in the highlighted area, then select FORMAT CELLS, and then choose PROTECTION, click the LOCKED button a tick should appear. The next time you protect the sheet (as locking cells doesn't work if the sheet is unprotected) just that row will be locked! Hope this helps, Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=498669 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Excelsheet
Hi, I guess you would have to select everycell on the sheet by clicking the top left corner then right click in the highlighted area, then select FORMAT CELLS, and then choose PROTECTION, click the LOCKED button until it shows empty i.e no tick or shading, then select the row you want to protect then right click in the highlighted area, then select FORMAT CELLS, and then choose PROTECTION, click the LOCKED button a tick should appear. The next time you protect the sheet (as locking cells doesn't work if the sheet is unprotected) just that row will be locked! Hope this helps, Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=498669 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
call excelsheet within excelsheet when user clicks excelsheet ico | Excel Worksheet Functions | |||
how to use an excelsheet that is already in my userform | Excel Programming | |||
How can i get autoformat name of range in excelsheet? | Excel Worksheet Functions | |||
How can i get autoformat name of range in excelsheet? | Excel Programming | |||
How to enter an excelsheet from a ppt presentation? | Excel Discussion (Misc queries) |