Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros to delete check boxes | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions |