Urgent! ! Disabling right click on spreadsheet

[Devanand]

Hi,
I am using OWC's Spreadsheet on a web page. My requirement
is,
1.users should not use right click and add/delete rows or
columns
2.I disaply them only 5 columns. When the press tab key at
the 5th column, It goes beyond 5th column.By anyway, we
can arrest the tab key?

Thanks in advance
Devanand

 

[Alvin Bruney]

you can have them use the right click just disable the column modification
like so

Set ptProtSheet =
document.all.sp.Worksheets(document.all.sp.ActiveSheet.Name).Protection

'this is optional

ptProtSheet.AllowFormattingRows = false

ptProtSheet.AllowFormattingColumns = false
'this is what you need


ptProtSheet.AllowInsertingColumns = false

ptProtSheet.AllowInsertingRows = false

ptProtSheet.AllowDeletingColumns = false

ptProtSheet.AllowDeletingRows = false


2.I disaply them only 5 columns. When the press tab key at

the 5th column, It goes beyond 5th column.By anyway, we
can arrest the tab key?

I'm not sure what you want to do here

 

[Devanand]

Hi!
Thanks for the quick response.
But I am sorry.
I used to assign sheet names and manipulate properties
using excel object from vb.

But i am not able to set the activesheet name in web page
and also,
I used your code in my page.It is not reactive.
Pls help me.

Instead, I tried using the property box by giving "protect
worksheet". In this case, its not allowing the user to
enter any data. I want my users to enter the data but not
to delete/add rows and columns.