Can't Delete Text Box

Klasdude

New Member
Joined
Sep 27, 2006
Messages
14
I have a basic spread sheet where I track my manpower. There are no formulas in the spread sheet. All I have is names divided up into separate columns and rows for each supervisor. Somehow, a text box got added to my spread sheet ("Text Box 2"). I click on the border of the text box, hit the "delete" button, but the text box doesn't delete. I have also right clicked on it and selected "cut" but the text box still remains. At first, I thought it was multiple text boxes laying on top of each other but then realized that every time I click on it, it has the same name (Text Box 2). I know nothing about VB but am pretty skilled at basic and intermediate Excel but can't figure out why this text box won't delete. It's not a big deal but now, it's a matter of pride. :) I'm not letting that text box beat me. lol
Any ideas???
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

BrianJN1

Well-known Member
Joined
Jun 15, 2017
Messages
603
I think that when you click on the text Box and choose "Cut" your mouse is inside the box! If so it's going to delete chosen content. Place your mouse on the border of the text box, right click and the see if you can "Cut".
 

Klasdude

New Member
Joined
Sep 27, 2006
Messages
14
I think that when you click on the text Box and choose "Cut" your mouse is inside the box! If so it's going to delete chosen content. Place your mouse on the border of the text box, right click and the see if you can "Cut".

No, I am clicking on the outside boarder and the text box itself is highlighted. I've done it MANY times this way and understand what you are saying but I can assure you, I have the box highlighted, not the text inside.
 

BarryL

Well-known Member
Joined
Jan 20, 2014
Messages
1,436
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
you need to enter design mode first. this is in the developer part of the ribbon. click design mode then delete.
 

Klasdude

New Member
Joined
Sep 27, 2006
Messages
14

ADVERTISEMENT

To add more to this, I can enlarge the text box, click elsewhere on the spread sheet and when I go back to the text box, it is the same enlarged size. However, after I go through the motions of deleting the larger/extended text box, "Text Box 2" returns to it's original smaller size in it's original position. Even if I move it to another position on the spread sheet, the original remains there, BOTH with the same name. I can delete the one that I have moved and it no longer appears, however, there is still "Text Box 2 in it's original position. It is almost as if there are multiple text boxes right on top of each other, however, I have "deleted" it at least 100 times and it still has the same name, "Text Box 2".
 

BarryL

Well-known Member
Joined
Jan 20, 2014
Messages
1,436
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
if after entering design mode and clicking delete and the textbox disappears, it then still reappears, you must have some VB code adding it in. Check your VBE for workbook/worksheet events.
 

Klasdude

New Member
Joined
Sep 27, 2006
Messages
14

ADVERTISEMENT

you need to enter design mode first. this is in the developer part of the ribbon. click design mode then delete.

I am on a work computer and it looks like our company has the "developer" option disabled. It is grayed out and I cannot add it. Clicking on the "Developer" tab, it is there but, again, it is grayed out. Probably good advice but looks like our administrator doesn't allow us do that. Thank you though Barry.
 

BarryL

Well-known Member
Joined
Jan 20, 2014
Messages
1,436
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
what happens if you press alt+F11?
 

MrIfOnly

Active Member
Joined
Nov 10, 2016
Messages
492
At this point you may want to consider copying and pasting your data into a new workbook and deletng this one.

Or, hire an exorcist. :devilish:

CJ<strike></strike>
 
Last edited:

Forum statistics

Threads
1,136,444
Messages
5,675,894
Members
419,591
Latest member
mersanko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top