Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Modifying a "Floating"(?) Cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DDB - 15 Jul 2006 20:16 GMT
Help!  I am a novice trying to modify a worksheet that someone else
created.  I am baffled by something that I can only describe as a
"floating" cell.  Essentially, it is a cell that has several different
assigned values that change when it is clicked.  For instance, "1"
appears first.  Then when it is clicked, "2" appears. The when it is
clicked again, "3" appears.  And then when it is clicked again, "1"
appears again.  I try to delete this cell, but I can't.  The reason
that I say that it is "floating" is that it covers up the cells below
it, and isn't influenced by the cells below it.  For example, I can
fill the entire worksheet with black cells, but this "floating" cell
isn't filled with black.

What is this this function called? And how do I turn it off?

Thanks for your help.

Signature

DDB

CLR - 16 Jul 2006 00:05 GMT
Sounds like it's a TextBox or a DrawingObjectbeing worked by a ChangeEvent
macro.............if you want to get rid of it, try Right-click >
Cut............but of course try it on a copy of your file..........

Vaya con Dios,
Chuck, CABGx3

> Help!  I am a novice trying to modify a worksheet that someone else
> created.  I am baffled by something that I can only describe as a
[quoted text clipped - 17 lines]
> DDB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36398
> View this thread: http://www.excelforum.com/showthread.php?threadid=561763
DDB - 16 Jul 2006 03:58 GMT
Right-clicking has no effect.  But you're correct that it has th
appearance of a borderless text box
SteveW - 16 Jul 2006 09:42 GMT
Try Ctrl+Click - then delete

> Right-clicking has no effect.  But you're correct that it has the
> appearance of a borderless text box.

Signature

Steve (3)

CLR - 16 Jul 2006 14:18 GMT
If it's a TEXT box, you may have to Left-click first, then Right-click on
the border, then CUT.......
Drawing objects may be deleted by just Right-click > CUT
Otherwise, you may have to get in to the change-event  code
editor..........if you're uncomfortable with that, you can send me a copy of
your file to my home addy.........croberts   at   tampabay   period   rr
period   com.............and I'll take a look

Vaya con Dios,
Chuck, CABGx3

> Right-clicking has no effect.  But you're correct that it has the
> appearance of a borderless text box.
[quoted text clipped - 4 lines]
> DDB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36398
> View this thread: http://www.excelforum.com/showthread.php?threadid=561763
DDB - 16 Jul 2006 22:06 GMT
No further assistance required.  

If anyone is interested, the problem was resolved i
View/Toolbars/Control Toolbox/Design Mode.

Thank you to "CLR" for his help
CLR - 16 Jul 2006 22:50 GMT
And thanks back to you David for thinking to close out the thread...........

Vaya con Dios,
Chuck, CABGx3

> No further assistance required.
>
[quoted text clipped - 8 lines]
> DDB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36398
> View this thread: http://www.excelforum.com/showthread.php?threadid=561763

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.