How to make my E- LEAVE APPLICATION FORM perfect

[niladri20052006]

Hi All,

I am trying to make an E- LEAVE APPLICATION FORM. But I am not making it perfect.

Only any employee will select his\her name first. (B2). The he \she will not get any chance to access any other cells.

Again employee has the permission to access when he\she has to fill B7 to E11.

Then he\she can not access any cells.

How will i make it perfect?

Any help or any idea


Please find the exact sheet from here

http://www.box.net/shared/yqof10lmrl14dz2x61bp

In the second sheet you will get the set of data with info...


Please help!!

 

[bensonsearch]

Wouldnt this be just locking the cells for editing so they can only change the ones you want them to?