delete checkboxes

[PK]

How do I go about deleting check boxes (400 + lines with 4 on each line)
copies from internet to an excel page, in one fell swoop? Or can't I.

 

[Ron de Bruin]

Hi PK

See
http://www.rondebruin.nl/controlsobjectsworksheet.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

How do I go about deleting check boxes (400 + lines with 4 on each line)
copies from internet to an excel page, in one fell swoop? Or can't I.
--
Ferret Mom

__________ Information from ESET Smart Security, version of virus signature database 3943 (20090317) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 3943 (20090317) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Alan]

Edit > Goto > Special > Check 'Objects' > OK will highlight them all, hit
Delete.
Note that this will delete all objects on the sheet, not just the
checkboxes,
Regards,
Alan.

 

[PK]

Wow, that works great and is easy. Do you have an easy method to remove all
hyperlinks too?

 

[Dave Peterson]

Select the range to remove the hyperlinks from (all the cells on the worksheet
if you want)

Then hit alt-f11 to get to the VBE
hit ctrl-g
type this:
selection.hyperlinks.delete
and hit enter

Then back to excel to check.

 

[Alan]

You can do it with a bit of code, here's how,

http://www.techonthenet.com/excel/macros/delete_hl.php

I don't know if it will help that much because although it removes the
hyperlinks, it turns them into plain text so you'll have to manually delete
all that,
Regards,
Alan.

 

[PK]

Are all versions of windows set up with the same F-Keys?

 

[PK]

Code really isn't my thing. I can do some basic formulas, including adding
figures from another workbook or page, but nothing more.

 

[Dave Peterson]

I don't know.

Heck, I don't know if all the versions of excel have the F keys the same. I
don't recall any difference between xl95 through xl2003. I haven't used xl2007
very much, but I haven't noticed any differences with that version, either.

Are all versions of windows set up with the same F-Keys?

 

[PK]

I didn't know the "F" keys were programmed at all?!? Hmmmm

 

[PK]

I had more time to look at that link, and it doesn't look as bad as I
thought, although I have NEVER done a macro before.

Thanks
--
Ferret Mom

Code really isn't my thing. I can do some basic formulas, including adding
figures from another workbook or page, but nothing more.

 

[Dave Peterson]

I think you'll find that almost all software (that does anything) used on a pc
has been programmed--including how the F keys work. <vbg>

I didn't know the "F" keys were programmed at all?!? Hmmmm