Remove Check Boxes

S

SlipperyZ

I have an Excel File that has 2 square boxes that look like check boxes and
what ever I do I cannot delete them. I checked for security and macros and
there are neither. When I double click on the boxes it sends me to the top
of the page.

Does anyone know how to delete these boxes?
 
E

Earl Kiosterud

Slip,

Make sure the sheet isn't protected (Tools - Protection - if you see
"Unprotect sheet," it's protected. Unprotect it).

I'm not sure about the sending you to the top of the page, and what that
means. Try this: Hold Ctrl as you click one. If it selects (a select box
with handles appears around it), press Delete. If that fails, get the
Control Toolbox (View - Toolbars) on the screen, and with the Design Mode
button lit, click a check box to select it. If it does, delete it.
 
M

mzehr

Hi,
First of all make sure that the worksheet is not shared or
protected.
Then go to view/Toolbars/Control Toolbox
click on the Design Mode Control (looks like a drafting
triangle). Then click on the selected control(s) and hit
the delete button. There is obviously some VBA code
controlling those buttons you may wish to delete. To do
so, right click on the sheet tab, select view code, and
you should be able to see the related code for those check
boxes you just deleted.
Highlite that routine, and delete.

HTH
 
R

Ruthy

Whenever you delete rows that have check boxes, the boxes do not delete with
the rows. You have to go into design mode, click on the box, and delete.
Continue the process over and over until all boxes are deleted. All the boxes
are on top of each other. You will need to continue this process for the same
number of times as the number of rows that were deleted.
 
Top