I'm using Excel 2002. There is a small yellow box, in the middle of a
spreadsheet, that I can't get rid of If I delete the row it's in, a row
gets deleted but this yellow box is still there. If I right click on it I
get 4 choices, cut copy paste view script. If I place the cursor over it, I
see "load TOCNode(1, 'moreinformation')". I can move it, expand it,
duplicate it (now I have three that I can't get rid of!). Inside the yellow
box is an angled scroll, or curlicue(?) icon.

Can someone tell me what this is and how I can delete it...

Thanks,

jc

It is a shape becaue deleting the row doesn't remove it. I suspect you
may have lots (maybe 100) of them sitting on top of each other so when
you remove 1 you think you didn't remove it because the one below
appears. You may have to remove lots of them before you get rid of then
all.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149284

Interesting...why would I have a hundred of them? I've moved them around
and there doesn't seem to be anything below the one I move, unless they all
move simultaneously. Anyway, how do I remove one?


"joel" wrote in message
...

It is a shape becaue deleting the row doesn't remove it. I suspect you
may have lots (maybe 100) of them sitting on top of each other so when
you remove 1 you think you didn't remove it because the one below
appears. You may have to remove lots of them before you get rid of then
all.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=149284

You are right. I didn't think if you moved the top one the other should
not moved unless they are grouped.

try this code.

for each shp in activesheet.shapes
shp.delete
next shp


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149284

If this is the only object on your entire worksheet, gotoeditgo
tospecialselect objects & ok out. All objects will be selected, just hit
"delete" and they should be gone.

If you have others and you only want to remove this one,
Gotoviewtoolbarselect "Control toolbox". On this toolbar you are looking
for the "design Mode" icon. It looks like a square with a ruler below it.
Select, this will show you all the objects on your worksheet. just select
the one (ones) you want gone and delete them

Mike Rogers

"jbclem" wrote:

Interesting...why would I have a hundred of them? I've moved them around
and there doesn't seem to be anything below the one I move, unless they all
move simultaneously. Anyway, how do I remove one?


"joel" wrote in message
...

It is a shape becaue deleting the row doesn't remove it. I suspect you
may have lots (maybe 100) of them sitting on top of each other so when
you remove 1 you think you didn't remove it because the one below
appears. You may have to remove lots of them before you get rid of then
all.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=149284



.

The little yellow box with a scroll icon inside is most likely a hyperlink. It's possible that someone accidentally created a hyperlink in the spreadsheet and it's now appearing as a yellow box with a scroll icon.

To delete the hyperlink, you can try the following steps:

1. Right-click on the yellow box with the scroll icon.
2. Click on "Hyperlink" from the drop-down menu.
3. In the "Edit Hyperlink" dialog box, click on "Remove Link".
4. Click "OK" to save the changes.

If the above steps don't work, you can try deleting the entire row or column that the yellow box is in. To do this, right-click on the row or column header and select "Delete". This should remove the yellow box as well.

If the yellow box still persists, it's possible that it's a glitch in Excel 2002. In this case, you may want to try closing and reopening the spreadsheet or even restarting Excel. If none of these solutions work, you may need to seek further assistance from Microsoft support.