Hi
one way:
- select all cells for which you want allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect your worksheet 'Tools - Protection'

"Asha" wrote:

i'musing a client side to open an excel file (vbscript) how can i add
function to this script that fix the number of row and column. if a user
wants to add a new value outside the fix row or column it wont be allowed to.
thanks in advance.