Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

character map

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bushy - 29 May 2008 08:34 GMT
I have a spreadsheet that has tick boxes in them that I cant delete or cut.
Please can anyone tell me how to do this and they are no longer required.
Rick Rothstein (MVP - VB) - 29 May 2008 09:27 GMT
I'm not sure what your Subject line has to do with your question... usually
it is a good idea to make them related. Also, you haven't given us a lot of
information to go on, but you can try the following procedures to see if one
of them works for you.

1) Right-click on one of the controls. If you get a shaded outline around
it, left-click on that outline (to get rid of the popup menu that probably
appeared and press the Delete key.

2) If you didn't get a shaded outline by right-clicking a control, then
click View/Toolbars on Excel's menu bar and click the Visual Basic item in
order to put a check mark next to it. Doing this will add the Visual Basic
toolbar to your worksheet. Click the Design Mode icon (it looks like a
triangle, ruler and pencil) to highlight it. Now left-click the control to
select it and then press the Delete key.

My guess is that one of the above procedures (or maybe both if you have a
mixture of controls) will let you delete the controls from your worksheet.

Rick

>I have a spreadsheet that has tick boxes in them that I cant delete or cut.
> Please can anyone tell me how to do this and they are no longer required.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.