Right Click

[Guest]

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.

 

[Guest]

Do you mean Shapes? There are many types of objects.

 

[Guest]

Yes - Autoshapes, rectangles, oval etc.

Do you mean Shapes? There are many types of objects.

 

[Chip Pearson]

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)

 

[Guest]

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

 

[zz]

try this

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