application.CommandBars("ply").enabled=false

--
HTH

-------

Bob Phillips
"Andoni " wrote in message
...
I have a workbook, I have to protect the workbook from copy paste
cut.... this is already done and working.


My problem:

1) How is it possible to disable the right mouse menu appearing when
you are over the sheet tabs and you right click the mouse?

If i don't do yhis my previous work is useless!

And despite cut copy and paste are disable, the option copy & copy and
move is still enable from the sheet tabs right mouse buton!


Many thanks


---
Message posted from http://www.ExcelForum.com/