ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check Box wont Delete (https://www.excelbanter.com/excel-discussion-misc-queries/29611-check-box-wont-delete.html)

Brandt

Check Box wont Delete
 
I have deleted 3 rows which contained a couple check boxes (from the "Forms"
toolbar) Now the check boxes are visible but cannot be selected,
checked/unchecked, or deleted off the page. I would like to remove them, but
can not figure out how. It must be something to do with the fact that the
cells that the boxes refer to are now non existant (#ref) because I can
select/check/uncheck all the other boxes on the sheet.

Any Suggestions?

Barb R.

You may need the "Select Multiple Objects" tool on the drawing toolbar.

"Brandt" wrote:

I have deleted 3 rows which contained a couple check boxes (from the "Forms"
toolbar) Now the check boxes are visible but cannot be selected,
checked/unchecked, or deleted off the page. I would like to remove them, but
can not figure out how. It must be something to do with the fact that the
cells that the boxes refer to are now non existant (#ref) because I can
select/check/uncheck all the other boxes on the sheet.

Any Suggestions?


Biff

Hi!

I tried to reproduce your problem and I *was able* to delete the checkboxes.
Did you try to right click them?

Biff

"Brandt" wrote in message
...
I have deleted 3 rows which contained a couple check boxes (from the
"Forms"
toolbar) Now the check boxes are visible but cannot be selected,
checked/unchecked, or deleted off the page. I would like to remove them,
but
can not figure out how. It must be something to do with the fact that the
cells that the boxes refer to are now non existant (#ref) because I can
select/check/uncheck all the other boxes on the sheet.

Any Suggestions?




Brandt

Barb,

Thank You! I was finally able to get it selected using that tool. It had
been shrunk down too small in the process of deleting the rows to be able to
select it in the normal manner.


"Barb R." wrote:

You may need the "Select Multiple Objects" tool on the drawing toolbar.

"Brandt" wrote:

I have deleted 3 rows which contained a couple check boxes (from the "Forms"
toolbar) Now the check boxes are visible but cannot be selected,
checked/unchecked, or deleted off the page. I would like to remove them, but
can not figure out how. It must be something to do with the fact that the
cells that the boxes refer to are now non existant (#ref) because I can
select/check/uncheck all the other boxes on the sheet.

Any Suggestions?



All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com