delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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

delete checkboxes
 

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


"Dave Peterson" wrote:

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

delete checkboxes
 

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

delete checkboxes
 

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


PK wrote:

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

"Dave Peterson" wrote:

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


--

Dave Peterson