Protected Excelsheet

[ngmahesh]

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

 

[Simon Lloyd]

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]

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