| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a click on + symbol to open a root and click on -. | Excel Discussion (Misc queries) | |||
| How to change syperlink from single click to double click | Excel Worksheet Functions | |||
| Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
Hybrid Mode
