[Solved] Unable to select chart

Question

Hi!

I have an Excelfile that I guess is corrupt, but I'm giving it a last chance by posting here.

The file contains multiple charts and all of a sudden all charts are impossible to work with. I cannot select chart och chart parts, its as the ActiveChart.ProtectSelection property is set to True. The charts are on separate chart sheets.

I have checked the following

• Sheets or Workbook is NOT protected
• Workbook is NOT shared
• Sheets are not grouped in the Excel file
• Programatically setting ProtectSelection = False for a chart does not help.

When trying to change the location of the chart by using VBA and ActiveChart.Location I get an error: "Reguested shape is locked for selection". So I have also tried looping through all shapes in workbook and change protection and lock setting, but no luck.

I run Win 8.1 and Office 2013, but I have also tried the file in Win 7 with Office 2007 and Office 2010. Same problem.

Im prepared to do the charts all over again but if anyone has any clues, please share. :)

/Leyan

Answer 1

Sometimes its a burdon to be an Excel technician, which I am. I tried all the fancy things with no luck. But just to cover it all I finally tried copying all sheets to a new workbook and... TaDa, all charts working as they should.

Lesson learned, start with the easy tests. :P

Still a very strange problem that I cannot explain.

Answer 2

Hello , 

I think that the error occurs normally when the chart is locked and the sheet is protected.

But it is not the case for you .

Try to check that sheets in workbook are not simultaneously selected.

If this not helps you , send me the file and i will try to fix that for you.

Thanks,

Ridha

Answer 3

Hello , 

Pls post your code here ! thanks

Answer 4

Hi,

Thanks for replying!

I edited my post a few minutes after posting, but maybe I did that after you read it. I added a record to my checklist: "Sheets are not grouped in the Excel file", in other words no simultanious selection of sheets.

So that was checked too, just forgot to mention it in the original post.

The file contains confidential data and cannot leave the building unfortunately.

Its like its stuck in ProtectSelection = True mode, because if I create a new file an run a macro setting ProtectSelection = True and protect the sheet I get the very same behaviour, but there I can of course just unprotect again. As its not protected in my problem file that doesnt work there ofc.

/Leyan