Delete Object NOT in cell?

[Daisyjim]

Hi. I have an excel sheet, where someone has imported an object. Its not within the cells, and i cannot delete or highlight. How on earth do i get rid of it?
Thank you!

[Richard Buttrey]

Hi,

What's the object? Can't you select it with a right click?

Upload the workbook so we can take a look. Anonymise any sensitive data if necessary

Regards

[Daisyjim]

Hi Richard.
I have tried everything i can think of: right click, undo object, clear all.... you cant seem to select the object in any form.
Have attached the document.
Thank you.

[martindwilson]

where is the object ,i see ....nothing !

[pike]

Daisyjim
The objects are protected with in the worksheet

[Daisyjim]

Oh!!
On my screen (and others), it appears in the top left box, covering the first 6 cells.
Strange.

[Richard Buttrey]

Hi,

You need to unprotect the worksheet first then right click on the buttons and delete them. The buttons run macros. Do you really want to do that?

Regards

[martindwilson]

have you got a screen print? i see nothing on any sheet in top left

[Daisyjim]

Buggar

The sheet wasnt set up by me, so i have no idea what the password will be. The macros are needed, so i guess im stuck?

[romperstomper]

I can't see the object in your screen print in any of the sheets in the file you posted.

[Daisyjim]

Richard - if i were to redo this excel, would you be able to help me ref the macros / set up?
Thank you

[Richard Buttrey]

Hi,

I can't see the object that you show in the Word doc either.

All I see are the buttons to run the macros which I assume now are not the objects to which you were referring.

Are you opening this across a network or from a local hard drive?

Having looked more closely, what I originally thought was a border around A1:A4, A6:A9 etc. are in fact drawing rectangle objects. Is it these rectangles that you want to remove?

Why anyone would want to draw a rectangle only to position it exactly around a cell range when a border is perfectly adequate is beyond me, but there you go.

If it helps I'm attaching the unprotected workbook. (There was nothing in the workbook or macros that appeared to be sensitive or copyright)

Regards