Hi!
I am generating a pie chart in excel with VBA. Once the pie chart is generated the code protects the sheet except for DrawingObjects. Excel 2016 users have no issues modifying the formatting of the chart with the code below but 2013 users cannot make changes to the chart. Can't drag titles outside, change colors, etc.
ActiveSheet.Protect Password:="xxxxx", DrawingObjects:=False
Any help would be appreciated.
I am generating a pie chart in excel with VBA. Once the pie chart is generated the code protects the sheet except for DrawingObjects. Excel 2016 users have no issues modifying the formatting of the chart with the code below but 2013 users cannot make changes to the chart. Can't drag titles outside, change colors, etc.
ActiveSheet.Protect Password:="xxxxx", DrawingObjects:=False
Any help would be appreciated.