hi everyone
i want to disable right mouse click on a scatter chart.
i need help
thanks a lot
Engin H.
hi everyone
i want to disable right mouse click on a scatter chart.
i need help
thanks a lot
Engin H.
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.
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.
>
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.
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks