How to Ungroup controls in a protected Excel sheet.

Question

Job of my Application is to scan excel files for activex controls.

Problem:

One of the sheet in an excel file is password protected with Activex control. Some controls are in grouped.

My tool showing error while scanning this sheet as follows:

"Exception from HRESULT: 0*800AO3EC"

For grouped controls but scan all other activex controls those are not in group.

Code is:

For Each shp As Microsoft.Office.Interop.Excel.Shape In objSheet.Shapes Select Case shp.Type Case MsoShapeType.msoGroup shp.Ungroup() y = 1 Flag = True Case Else Flag = False End Select Next

I am getting error in the above highlighted line.

Please help me:

Whether it is possible to scan grouped controls in Protected sheet or not.

If yes, then please provide me some solutions.