Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 09, 09:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 33
Default What is this little yellow box with a scroll icon inside?

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



  #2   Report Post  
Old October 29th 09, 10:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 1
Default What is this little yellow box with a scroll icon inside?


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

  #3   Report Post  
Old October 29th 09, 10:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 33
Default What is this little yellow box with a scroll icon inside?

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



  #4   Report Post  
Old October 29th 09, 11:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 1
Default What is this little yellow box with a scroll icon inside?


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

  #5   Report Post  
Old October 30th 09, 12:20 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 284
Default What is this little yellow box with a scroll icon inside?

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



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula for if Cell c1 is yellow shaded cell d1 should be yellow Hardeep Excel Discussion (Misc queries) 1 October 27th 05 02:58 PM
Scroll horizontaly with mouse, create same system used to scroll . frederic New Users to Excel 5 October 9th 05 08:15 PM
IF the cell is yellow... Connie Martin Excel Discussion (Misc queries) 7 July 28th 05 07:35 PM
What is this yellow box? ..Not a comment MistWolf Excel Discussion (Misc queries) 2 May 29th 05 02:09 AM
why is my excel icon a yellow-white exclamation point now? what . megan Excel Discussion (Misc queries) 1 April 23rd 05 11:04 PM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017