how to programmatically fix row and column
 

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.

how to programmatically fix row and column
 

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.

how to programmatically fix row and column
 

In addition to Frank's suggestion of using locked cells and sheet
protection,
Look at the scrollarea property.

--
Regards,
Tom Ogilvy

"Asha" wrote in message
...
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.