In my excel worksheet I don’t want user to delete and insert row or columns (right click/delete/insert)
How could I take out that functionality from my work sheet?
Is there any way I can gray out those 2 things from right click, that will help I guess.
Thanks in advance.

Just check if the following link can help you

http://vbadud.blogspot.com/2007/04/d...ght-click.html
Cheers
Shasur

http://www.dotnetdud.blogspot.com

Thanks for your feedback.
I tried that

Application.CommandBars("CELL").Enabled = False

That disappear whole right click capability.
Is there way can I take off only Insert and Delete from right click on a specific worksheet?
thanks

Here you have it

Sub Disable_Buttons()

Dim oC1 As CommandBar

Set oC1 = Application.CommandBars("CELL")
oC1.Controls("Cu&t").Enabled = False
oC1.Controls("&Copy").Enabled = False

End Sub

Cheers
Shasur

http://www.dotnetdud.blogspot.com

Thanks Shasur for your reply.
It works great for cut and copy.

I was looking for Insert and Delete.
Maybe I didn't explain enough earlier.
I use similar way, you did for delete and insert
but didn't work. Any idea?
Thanks

Can you try the following

oC1.Controls("&Insert...").Enabled = False
oC1.Controls("&Delete...").Enabled = False

Cheers
Shasur

http://www.dotnetdud.blogspot.com

Same as before no right click menu.
Even if I open another excel spreadsheet no right click capability unless I close the existing one.
I deleted the code still there is no right click menu.
I thing something with excel macro causing.

You can turn that on

oC1.Controls("Cu&t").Enabled = True
oC1.Controls("&Copy").Enabled = True
oC1.Controls("&Insert...").Enabled = True
oC1.Controls("&Delete...").Enabled = True

after your job is done

cheers
shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)