| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting check boxes
Greetings,
I need to delete a number of check boxes which i copied over from an HTML document into Excel. I have the code: Sub DelAllCb() Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.FormControlType = xlCheckBox Then shp.Delete End If Next shp End Sub But this does not work, is it the format of the check box below? =EMBED("Forms.HTML:Checkbox.1","") Please heeellp!! Tempy *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| Problem Deleting Check Boxes created from Forms Toolbar | Excel Discussion (Misc queries) | |||
Threaded Mode
