Home |
Search |
Today's Posts |
#1
|
|||
|
|||
disable right mouse click on a scatter graph?
hi everyone
i want to disable right mouse click on a scatter chart. i need help thanks a lot Engin H. |
#2
|
|||
|
|||
By default, a chart embedded in a protected worksheet is Locked. This
means it updates as the data updates, but the user can't change it. If it's feasible, unlock the cells the user is allowed to change, then protect the sheet. In a protected chart sheet, the right click menu items are disabled. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Engin H. wrote: hi everyone i want to disable right mouse click on a scatter chart. i need help thanks a lot Engin H. |
#3
|
|||
|
|||
dear Jon
i am working on .Net environment, i tried before as you wrote below, oChart.Protect("123", True, True, True) bu it did not work, still all controls are enabled when i right click on chart :( "Jon Peltier" wrote: By default, a chart embedded in a protected worksheet is Locked. This means it updates as the data updates, but the user can't change it. If it's feasible, unlock the cells the user is allowed to change, then protect the sheet. In a protected chart sheet, the right click menu items are disabled. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Engin H. wrote: hi everyone i want to disable right mouse click on a scatter chart. i need help thanks a lot Engin H. |
#4
|
|||
|
|||
In Excel VBA, these two procedures are exactly what is needed to protect
a chart sheet: Sub ProtectChart() Dim oChart As Chart Set oChart = ActiveChart oChart.Protect "abc", True, True, True, True End Sub Sub UnProtectChart() Dim oChart As Chart Set oChart = ActiveChart oChart.Unprotect "abc" End Sub The code is different for an embedded chart, because such a chart cannot be protected, only locked, while its parent sheet can be protected. It's hard to see the context of your command, with only that command posted. On the other hand, I am not experienced in .Net, so the context may not help. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Engin H. wrote: dear Jon i am working on .Net environment, i tried before as you wrote below, oChart.Protect("123", True, True, True) bu it did not work, still all controls are enabled when i right click on chart :( "Jon Peltier" wrote: By default, a chart embedded in a protected worksheet is Locked. This means it updates as the data updates, but the user can't change it. If it's feasible, unlock the cells the user is allowed to change, then protect the sheet. In a protected chart sheet, the right click menu items are disabled. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Engin H. wrote: hi everyone i want to disable right mouse click on a scatter chart. i need help thanks a lot Engin H. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I grab graph coordinates in Excel via the mouse with VB? | Charts and Charting in Excel | |||
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . | Charts and Charting in Excel | |||
Each Click of the Mouse | Excel Discussion (Misc queries) | |||
creating a directed graph from XY scatter | Charts and Charting in Excel | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel |