| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Modifying a "Floating"(?) Cell
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. -- DDB ------------------------------------------------------------------------ DDB's Profile: http://www.excelforum.com/member.php...o&userid=36398 View this thread: http://www.excelforum.com/showthread...hreadid=561763 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Modifying a "Floating"(?) Cell
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 "DDB" wrote in message ... 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. -- DDB ------------------------------------------------------------------------ DDB's Profile: http://www.excelforum.com/member.php...o&userid=36398 View this thread: http://www.excelforum.com/showthread...hreadid=561763 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Modifying a "Floating"(?) Cell
Right-clicking has no effect. But you're correct that it has the appearance of a borderless text box. -- DDB ------------------------------------------------------------------------ DDB's Profile: http://www.excelforum.com/member.php...o&userid=36398 View this thread: http://www.excelforum.com/showthread...hreadid=561763 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Modifying a "Floating"(?) Cell
Try Ctrl+Click - then delete
On Sun, 16 Jul 2006 03:58:46 +0100, DDB wrote: Right-clicking has no effect. But you're correct that it has the appearance of a borderless text box. -- Steve (3) |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Modifying a "Floating"(?) Cell
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 "DDB" wrote in message ... Right-clicking has no effect. But you're correct that it has the appearance of a borderless text box. -- DDB ------------------------------------------------------------------------ DDB's Profile: http://www.excelforum.com/member.php...o&userid=36398 View this thread: http://www.excelforum.com/showthread...hreadid=561763 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Modifying a "Floating"(?) Cell
No further assistance required. If anyone is interested, the problem was resolved in View/Toolbars/Control Toolbox/Design Mode. Thank you to "CLR" for his help. -- DDB ------------------------------------------------------------------------ DDB's Profile: http://www.excelforum.com/member.php...o&userid=36398 View this thread: http://www.excelforum.com/showthread...hreadid=561763 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Modifying a "Floating"(?) Cell
And thanks back to you David for thinking to close out the thread...........
Vaya con Dios, Chuck, CABGx3 "DDB" wrote in message ... No further assistance required. If anyone is interested, the problem was resolved in View/Toolbars/Control Toolbox/Design Mode. Thank you to "CLR" for his help. -- DDB ------------------------------------------------------------------------ DDB's Profile: http://www.excelforum.com/member.php...o&userid=36398 View this thread: http://www.excelforum.com/showthread...hreadid=561763 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Hybrid Mode
