Unlocking charts

N

Noz2k

Well-known Member
Joined
Mar 15, 2011
Messages
693
Is it possible to uncheck the locked property of a chart so that is can be moved/deleted on a protected worksheet?

At the moment I have a button which unprotects the sheet, creates the chart and then protects the sheet again. But I would like it so that the use can move the chart to view the information behind, and also click on the chart to delete it.

Is this possible or, will I need to insert a command button to delete the chart?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Solved it.

Just in case anyone has a similar problem the solution was to set the name property, then activate the chart and unlock the selection.

So like
Code: 
ActiveChart.Parent.Name = "Graph"
    Sheets("Sheet2").ChartObjects("Graph").Activate
    Selection.Locked = msoFalse
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Error deleting embedded charts from a worksheet when there are no charts
Replies
6
Views
348
NdNoviceHlp
NdNoviceHlp
A
  • Question Question
VBA help - Locking & unlocking on certain times of day
2
Replies
17
Views
458
dmt32
D
Q
  • Question Question
Slicer Query
Replies
0
Views
250
quinn_Nor
Q
A
  • Question Question
Creating a Pie Chart of a segment of a stacked bar in a Grouped Bar Chart (the bar chart I made is attached)
Replies
0
Views
324
afrailer
A
M
  • Solved
M365 and moving through chart series
Replies
2
Views
244
mikejvir
M

Forum statistics

Threads
1,224,602
Messages
6,179,844
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top