try this

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


--
hope this works!
---
zz [MX]
cuasi-musico,semi-poeta y loco

"Ronbo" wrote in message
...
Thanks Chip - Shapes was easy enough. I was hoping Charts would be that
easy,
but it does not work with chart or charts.

I want to remove the two right clicks menus on a chart 1) format plot area
menu 2) format chart area menu.

Thanks,
Ronbo


"Chip Pearson" wrote:

For shapes, it would be

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



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Ronbo" wrote in message
...
What is the code to delete the right click on objects and charts like
"Application.CommandBars("Cell").Enabled = False" removes the right
click
on
cells?

Thanks for any help. It is always appreciated.