How to remove an accidental embed Excel 2010 `I have gotten a blank space locked

Question

How to remove an accidental embed Excel 2010

`I have gotten a blank space locked to a cell in a spreadsheet . The cell shows it as a function EMBED hidden. and it hides the actual cell value. Its now movable, nor deletable. The actual value in the cell remains there but it is not visible. If I copy and paste the rows in another location the information is visible but the whole sheet can't be copied to a new sheet to get rid of the embed. Any duplication of the sheet causes the embed to stay. The embed also shows as a control of some type..

Thanks for help !!

Explanation / Answer

Hi..

Have you tried right-clicking to "capture" the object and then selecting "Cut" from the pop-up menu? I suspect you have some type of embedded Active X control in the cell.

You may want to expand the size of the cell by increasing row height/column width long enough to give this a try.

[Edit] If the object is an ActiveX control, you'll probably have to go to the [Developer] ribbon and click the "Design" icon in order to capture it with a right click.

If this fails, you can try this VBA code which will remove ALL "objects" of type Shape which includes controls. Hopefully you don't have anything else like textboxes and such on the sheet that it will also remove:

Sub RemoveObjects()
Dim anyObject As Shape
For Each anyObject In ActiveSheet.Shapes
    anyObject.Delete
Next
End Sub

To use the code: open the workbook, select the problem sheet. Press [Alt]+[F11] to open the VB Editor and then choose Insert --> Module and copy the code and paste it into the code module. Place your cursor anywhere within the code and press the [F5] key. After that you can delete code (and even the module). If the workbook doesn't have any other macros at all in it, you can later save the file as type .xlsx to remove all traces of the code/code module.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.