a macro for deleting checkboxes

[mackinlay]

Hi everyone,

I have a macro that creates a checkbox and some writing in a cell... pretty simple. But every time this macro is used the checkbox that is created is defaultly named "CheckBox 39", then next time "CheckBox 40", then "CheckBox 41" etc etc...

This means that the separate macro that I'm trying to write to delete the checkbox and writing that is made is puzzling me. I can't specify the checkbox name because it changes each time the macro is run, but similarly it doesn't recognise me changing the name to something else and then searching for the box named that.

Has anyone got any ideas of how I can basically highlight a checkbox that appears in a specific place on a worksheet, so can then simply delete it?!

A simple but bizare problem nonetheless!

Cheers guys,

Alex

[royUK]

It would probably be easier to help if you posted the code that you are using, remember to use Code Tags.

[mackinlay]

This is the code for creating the writing and checkbox:

Please Login or Register  to view this content.

and I am tring to delete it with:

Please Login or Register  to view this content.

it is the line "ActiveSheet.Shapes("sub1").Select" that is the problem!

Hope this helps!