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

Hi PK

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


--

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




"PK" wrote in message ...
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

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" wrote in message
...
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

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


"Alan" wrote:

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" wrote in message
...
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

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.

PK wrote:

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

"Alan" wrote:

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" wrote in message
...
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



--

Dave Peterson

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


"Dave Peterson" wrote:

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.

PK wrote:

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

"Alan" wrote:

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" wrote in message
...
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



--

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.

PK wrote:

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

"Dave Peterson" wrote:

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.

PK wrote:

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

"Alan" wrote:

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" wrote in message
...
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



--

Dave Peterson


--

Dave Peterson

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" wrote in message
...
Wow, that works great and is easy. Do you have an easy method to remove
all
hyperlinks too?
--
Ferret Mom


"Alan" wrote:

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" wrote in message
...
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

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


"Alan" wrote:

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" wrote in message
...
Wow, that works great and is easy. Do you have an easy method to remove
all
hyperlinks too?
--
Ferret Mom


"Alan" wrote:

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" wrote in message
...
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

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


"PK" wrote:

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


"Alan" wrote:

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" wrote in message
...
Wow, that works great and is easy. Do you have an easy method to remove
all
hyperlinks too?
--
Ferret Mom


"Alan" wrote:

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" wrote in message
...
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