Modifying a "Floating"(?) Cell

  • Thread starter Thread starter DDB
  • Start date Start date
D

DDB

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.
 
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
 
Right-clicking has no effect. But you're correct that it has th
appearance of a borderless text box
 
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
 
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
 
And thanks back to you David for thinking to close out the thread...........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top