Right Click
 

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.

Right Click
 

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

"Ronbo" wrote:

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.

Right Click
 

Yes - Autoshapes, rectangles, oval etc.

"JLGWhiz" wrote:

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

"Ronbo" wrote:

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.

Right Click
 

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.

Right Click
 

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.

Right Click
 

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.