Modifying a "Floating"(?) Cell DDB <DDB.2b043h_1152991209.7162[ at ]excelforum-nospam.com> 15.07.2006 19:16:45 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?action=getinfo&userid=36398 View this thread: http://www.excelforum.com/showthread.php?threadid=561763

Re: Modifying a "Floating"(?) Cell "CLR" <croberts[ at ]tampabay.rr.com> 15.07.2006 23:05:12 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" <DDB.2b043h_1152991209.7162[ at ]excelforum-nospam.com> wrote in message news:DDB.2b043h_1152991209.7162[ at ]excelforum-nospam.com... [Quoted Text] > > 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?action=getinfo&userid=36398 > View this thread: http://www.excelforum.com/showthread.php?threadid=561763 >

Re: Modifying a "Floating"(?) Cell DDB <DDB.2b0pe9_1153018813.9266[ at ]excelforum-nospam.com> 16.07.2006 02:58:46 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?action=getinfo&userid=36398 View this thread: http://www.excelforum.com/showthread.php?threadid=561763

Re: Modifying a "Floating"(?) Cell SteveW <sj_walton[ at ]nothotmail.com> 16.07.2006 08:42:51 Try Ctrl+Click - then delete On Sun, 16 Jul 2006 03:58:46 +0100, DDB <DDB.2b0pe9_1153018813.9266[ at ]excelforum-nospam.com> wrote: [Quoted Text] > > Right-clicking has no effect. But you're correct that it has the > appearance of a borderless text box. > > -- Steve (3)

Re: Modifying a "Floating"(?) Cell "CLR" <croberts[ at ]tampabay.rr.com> 16.07.2006 13:18:38 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" <DDB.2b0pe9_1153018813.9266[ at ]excelforum-nospam.com> wrote in message news:DDB.2b0pe9_1153018813.9266[ at ]excelforum-nospam.com... [Quoted Text] > > 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?action=getinfo&userid=36398 > View this thread: http://www.excelforum.com/showthread.php?threadid=561763 >

Re: Modifying a "Floating"(?) Cell DDB <DDB.2b23ut_1153084209.1848[ at ]excelforum-nospam.com> 16.07.2006 21:06:01 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?action=getinfo&userid=36398 View this thread: http://www.excelforum.com/showthread.php?threadid=561763

Re: Modifying a "Floating"(?) Cell "CLR" <croberts[ at ]tampabay.rr.com> 16.07.2006 21:50:44 And thanks back to you David for thinking to close out the thread........... Vaya con Dios, Chuck, CABGx3 "DDB" <DDB.2b23ut_1153084209.1848[ at ]excelforum-nospam.com> wrote in message news:DDB.2b23ut_1153084209.1848[ at ]excelforum-nospam.com... [Quoted Text] > > 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?action=getinfo&userid=36398 > View this thread: http://www.excelforum.com/showthread.php?threadid=561763 >