Can't do anything with a hidden object??

Waldemar

New Member
Joined
Feb 3, 2005
Messages
21
hi there,
I'm struggeling with a very odd problem.. a worksheet contains objects which can't be touched.. no properties, no nothing, only.. they excist and they mess up a pdf file I need to make from the sheet.

On this url :
http://members.home.nl/whof/temp/test.xls
I've placed an empty test.xls with a few cells with these mysterious objects

When opening the file an alert says another worksheet is connected to this sheet.
Could be right, the cells are coming from a graphics document with data based in a data spreasheet called 'analysis'
But as you can see, this test xls is empty! There is nothing! The 'objects' appears to be situated on the cellborders!
You can't delete, but you can drag, copy and after a number of actions the famous "no more fonts could be applied" message appears...

I hope some of you knows what has happened - and how to solve this problem!
Thanks!

Waldemar
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,343
Office Version
  1. 365
Platform
  1. Windows
Waldemar

Have you tried going to Edit>Goto... and selecting Objects?

I just did and then went to Edit>Cut.

It took some time but it seemed to get rid of these objects, if that's what you want.

By the way the Chart toolbar appeared when I had selected them.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,343
Office Version
  1. 365
Platform
  1. Windows
Also I just did this small test and put a watch on ws.
Code:
Sub test()
Dim ws
     Set ws = ActiveSheet
End Sub
It appears to contain 144 shapes, I'm still trying to work out what they actually are.
 

Waldemar

New Member
Joined
Feb 3, 2005
Messages
21
Thanks Norie, this is indeed what I need.. to delete them. It will take some time to do this action on the real working sheet because this sheet is full of objects I want to keep, but at last whith your method I can actually grab these 'things' .
Thanks very much, It took me already a lot of time, but I never tried the goto command.
But it is still mysterious isn't it :)

Waldemar
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,802
Messages
5,833,755
Members
430,230
Latest member
Doug G

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top